Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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.
I am trying to find a way to look at text fields and automatically remove date and time stamps plus employee names. Any recommendations on identifying and removing text strings that meet the below formats: YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] We have a…
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
Does anyone know how to revert a sheet to a prior version after a column formula resulted in replacing all of the values with #circular reference? Would all entries have to be manually re-entered?
