I want to be able to identify the user when changes are made to cells on the Sheet. I know there is the Activity Log. But I want to see that data on the Sheet. I also know that there is the Modified B…
Hello All. I have a sheet that has staff name and their term date. I want Smartsheet to look at this sheet daily and send an email to HRC with details of staff whose term date is 14 days from now. to …
Greetings, I'm trying to set up an automation to send an email 7 days after creation date but I'm having problems. I tried using the function =IF([Creation Date]@row) > TODAY(+7), 1, 0) but it isn't w…
Hello, I have an automation that I want to run after a form is submitted with an output that is generated by the form answers. In testing it, I would like to be able to remove the "1 row added" and th…
I'm making a conditional checking but during the mapping process, I'm asked to specified a column on where to send it. Since I'm having 2 different columns: "Created By" & "Contact List", I can only s…
Hello. I'm using the Smartsheet Individual Productivity Hub template and I can't get the Completed Tasks automated workflow to work. I've checked the automation and the condition is set that if the st…
In my workflow I am able to get an email from my first condition (see "Condition 3"), in the second one or any after that, SmartSheets will not email me even though that is the action requested to do …
Context: We have a Form that was created about 5 months ago for Tech Request Tickets for our company (all internal). Within our company, we all have Smartsheet accounts. We had an issue of auto-popula…