Sign in to join the conversation:
I want to create a formula in a cell that subtracts a certain number of days from another cell that is linked to another persons Smartsheet. How would I do that? My efforts have failed.
Hi there,
This is pretty simple. After you have linked the cell... you can use simple math to adjust the days. For instance. If you have a linked cell in [Column2] row 3 and want to add 10 days to it. In a new column (set up as a date column) and row, use the following formula. Do note that because you are creating a new date you need to use the Date Column type to make that happen.
=[Column2]3 + 10
If you want it to be 10 days before that date use this formula
=[Column2]3 - 10
If you want it to be 10 working days after the linked cell date and you have set up your working days in your account settings.
=Workday([Column2]3,10)
Or 10 days before.
=Workday([Column2]3,-10)
Hope that helps!
Is there a way to automatically notify an operator as they are updating a form and hit submit that their entries do not match and it's a failed audit other than email notification? ex. Audit is for ensuring batch numbers match from 2 items. If the operator enters a batch that doesn't match, we would like them to be aware…
I used the AI chat to help create a formula to multiply PPU by STOCK and apply the sum to the entire INVENTORY VALUE $ column. =[PPU] * [STOCK] Why is the sum not populating in the "INVENTORY VALUE $" column? I have the properties set to American $… I think. The AI chat said there may be an issue with the sheet set up This…
i have dependencies enabled in my project, all start/end/durations populated, and critical path button selected, but critical path is not showing in gantt view nor list view with critical path filter
