Hello I would like to read the content of a cell every day, e.g. day1->read row 1, day2->read row2 etc…
Thanks a lot
Welcome to the Make community!
You can certainly reference a different row based on the day of the week.
It looks like you are using Google Sheets, and in the “Get a Cell” module, you can simply use “A” plus the formatDate function with the format “d” to get the day of the week from 0-6, where 0=Sunday.
Then, you’ll need to add 1 because your rows start from 1. For that use the sum function.
Output:
3 Likes
Hello,
Thank you so much it is really hlepful, I have an additional question. How should I use dateformat to retrieve the week of the year ? Instead retrieving the day of the week I would like to retrieve the week of the year. any suggestion ?
Many thanks in advance.
Actually i am looking for something similar =WEEKNUM() in excel
According to the Tokens you can use to format a date variable, you can use w or ww.
e.g.: formatDate({{now}};w)
3 Likes
In future, you should create a new thread for each question. This makes it easier for others with the same problem to search for the answer. Thank you for your cooperation!
The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
- others can save time when catching up with the latest activity here, and
- allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post:
2 Likes
So many thanks, I take a note for the future, Have a good day.
2 Likes