From looking at forums, it seems that this is not yet a function of SmartSheets. If I were to set an automation function for a row to move from one sheet to another (e.x. from "Active Grants" to "Clos…
Hi all, Sometimes i need to add new data to a dropdown list but it's hard for me to add because it's in a lot of different sheets. How do i automatically add data to all dropdown list column? (Python,…
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…
