The ability to explicitly create an order of execution for automations rather than relying on the last modified date would be beneficial to Smartsheet Designers. My suggestion is to add a dependency d…
I have a calculation sheet with the formula =COUNTIFS({Sent to AIR-360}, >[FY Start Date]@row, {SR Type}, ="NTSB", {Sent to AIR-360}, >{AIR-360 Due Date}). The formula is to count dates greater than F…
I suggest changing terminal actions such as the "Record a date" and "Change cell value" actions to non-terminal actions. There are many times when I would like to record a date or change a cell value …
I have been looking at the various conversations on using a COUNTIFS with an embedded CONTAINS function, but have had no success getting it to work. In the below formula I want to count "FAA Domestic"…
I am looking for help get the below equation to behave like I want. Currently it gives me #INVALID OPERATION, which I have trouble shot and determined it is giving me this because it is trying to perf…
I am getting an #UNPARSEABLE error in the below formula. The formula is to return "See Total Time to Close Column" if the Total Time To Close column is not blank, otherwise, perform the calculations. …