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 would like to automate a due date of 5 weeks from the creation date unless the status is “On Hold”. Then the date should be blank. When the status changes from “On Hold” to "Open" then the date can be recalculated as above. Unclear how this can be done.
@Cath Jones
Change the column names to match your column names. Add the formula to your Due Date column - ensure that it is setup as a Date column.
=IF([Status]@row = "Open", [Created]@row + 35, "")
This is giving you a date if status = Open, or blank for any other status.
Hope this help!
Hi All, I'm working on a formula that is evaluating three columns of data: 1) EOY Target Weighted MWh 2) Forecast Weighted MWh 3) Increase/Decrease (to determine if the goal for the year is to increase or decrease the MWh) Here is my current formula: =IF([Forecast Weighted MWh]@row = [EOY Target Weighted MWh]@row, "On…
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
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…
