RossL
RossL
Reactions
-
Re: Move or copy row workflow results in empty rows in destination sheet
It is the way smart sheet is set up. The last row for the automated moves or even forms adding lines will go below the last row that has ever had anything in any of the cells. I know I like to try ou…1 · -
Re: Record a date automation not working?
@Kate Allison I have noticed it will populate after a save and refresh but it might be delayed at the moment. looking at the Smartsheet status page1 · -
Re: Automatically change Status RYGB
If you want to automate the status to go to blue the other colors will need to be called out too. for example if % Complete = 100% Blue IF % Complete is less than 75% and the end date is in the next …1 · -
Re: Can I apply Conditional Logic to Picklist Values in a Form?
you wold need a drop down column for each state that only has the companies in that state. then use conditional logic in the form to only show the drop down for what ever state is selected. it would …1 · -
Re: IF condition statement from multiple columns & properties
@Shane Sorensen does column C being checked make it green no mater if B is blank or not? If so try this =IF(C@row = 1, "Green", IF(ISBLANK(B@row), "Yellow", "Red"))1 ·
