Sign in to join the conversation:
How do I create a formula to subtract 30 business days from a certain start date?
I was trying to use =WORKDAY ([start date]13, -30) and it's not working. Note: the 13 is the row with the date I'm counting back from.
Thanks for your help!
That formula should work. I just tested it myself. Is the column you are putting the formula in formatted as a Date Column?
That's it! It was a text column - thank you so much!
It does work now but it's counting back calendar days and not work days - any ideas??
Hmm... I'm not sure. I just tested it again, and it was counting "workdays" (Monday - Friday). Putting in a start date of 6/29 gives me a result of 5/18.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
