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!
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
