Trending in Smartsheet Basics
Is it possible to add a pattern (e.g., diagonal lines) to a dashboard chart?
Setting up a weekly automation to alert someone in 30, 60 and 90 days of a date
I have a sheet that tracks employees certifications. I'd like to setup a single automation that runs weekly to alert the employee when the expiration date is within 180, 90, 60 and 30 days away. I'd prefer that the 180 day alert only be sent monthly until the 90 day date is hit, then weekly. I'd like the message sent to…
Need to determine the stage of a house by the dates submitted
Our builders submit dates at each critical stage. I need to write a formula to show what stage the house is in by the looking at the latest date submitted. Any thoughts to what function i should use. Trying to give the last column "Stage of Job", an answer of Slab, Frame, Cabinets or Final CO, based on the latest date…