Sign in to join the conversation:
Can someone help me with a formula,
I want the formula to calculate a date 30 days before and 30 days after if the cell Says Lead Service Job
I tried =IF(Status128 = "Lead Service Job", [Lead Service Start date]128 (+ 30)
Be sure your formula is a Date type column or it won't work. You almost had it otherwise with character out of place. Try this:
=IF([Status]@row = "Lead Service Job", [Lead Service Start date]@row + 30)
I have a form that will be filled out internally. There's a cell labeled "Department" which contains 8 dropdown list values. There's a another cell called "Executives" which are the leaders of these departments. In the form, I'm attempting to do a logic where when you choose a specific "Department", then the cell…
I shared access to a user to a specific folder under workspace A (folder is 2025-09-Service Factory). However, I can see that he's shown to have access to all the other child folders under 02-ACTIVE Initiatives. Why is that when I only shared out one folder? Is there a way to only share access to users to ONLY specific…
what i can do if all my existing smartsheet gant files can't be open after change my plan to Pro? what could be the reason ?
