I have my start date auto filled when I enter information into a new row. I now want my due date to auto fill to 7 work days after the start date. How do I do this?
Right now I have this for row 5
=WORKDAY([Start Date]5 + 7)
Any help would be great!
You can reference the formula for workdays here: https://help.smartsheet.com/function/workday
You were close. =Workday([Start Date]5, 7)
You can also use @row instead of calling the row number to ensure your date is always accurate to the row its on.
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
