Sign in to join the conversation:
How can I get the =WEEKNUMBER consider a week from Monday to Sunday. I have some entries on Sundays that is showing week number of following week.
Weird - Do you have an example date where this is happening?
From the notes:
Hi,
I am actually coming across the same issue and need the weeknumber to calculate Sunday to Saturday. Is there any way that the formula can be adjusted for this?
Thank you,
Crystal
Here is what I came up with, if this is still relevant to you.
=IF(WEEKDAY([Work Day]@row) = 1, WEEKNUMBER([Work Day]@row) + 1, WEEKNUMBER([Work Day]@row))
where Work Day is when the employe worked. So I tricked the system in adding 1 to the weeknumber when the day number is 1 (so this Sunday end up next week) making it a week from Sat to Sun.
I am creating a sign-up form for an event, in which people will select a time slot to attend (1:00, 1:15, 1:30, etc.). There are 12 possible selections, and I can have a maximum of 4 people select each option. It would be wonderful if after the fourth time an option is selected it either disappears, is greyed out, or the…
Hello…..Iam needing help with a forms question. How do I set it up where when someone sends in a form, I then get the same email form?
Hi All, I’m looking for some guidance on how to best structure an activity plan in Smartsheet. I need to track and display: Date ranges for each activity Activity month Monthly budget Key points such as promos/offers Major events happening during the same period (e.g., national holidays, International Women’s Day, etc.)…
