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.
Hi Smartsheet, What's the current max-cell-count for grid view? Is there an easy way to identify where the sheet is at for cell count? I've asked AI a few times, ways. It's a little confused today. Also did a few count( formulas, but Excel seemed to produce a better assessment. 🤨 Thx, Eric
Hello, I have a form for our team to complete each week to obtain a pulse check. I am trying to tally the responses from the team to show in a table on the dashboard, however, I cannot get it to display how I would like for it to. I want the horizontal axis to show the categories (columns) and for the vertical axis to be…
This discussion was created from comments split from: Change Permissions for Specific Items in Workspace.
