-
Help with automation to find bad formatting
I have a sheet accessed by monkeys users who keep managing to muck up a currency column. They are either pasting in amounts from some other source or literally typing in the dollar sign followed by a number, or something. The result is reports that lose their currency formatting. Smartsheet seems to treat these bad entries…
-
Automation to Send Notification to Shared Mailbox
I am trying to send a notification to a shared mailbox, when a row is added (from a form), with certain criteria within one of the fields on the row. Ideally this row would contain the information from the submission (similar to what is sent when submitter selects 'Send me a copy of my responses'). If this is possible,…
-
How to maintain formula generated data when a line moves to another sheet
I have a sheet that is arranged with parent/child lines to track new recruits for positions within the company. The parent line is the position name and the child lines are the individual recruits being considered. When we're done hiring, we'd like to keep some recruit's info for future hiring, but in another sheet. I set…
-
Merged: Log automated workflow actions on the Activity Log
This discussion has been merged.
-
How to prevent or recover deletion of rows
Is it possible to prevent the deletion of rows in a sheet? Specifically, in cases where a user legitimately requires editor permission to the underlying sheet and where the row cannot be locked (as continued editting of the row is required.) If not, what are some strategies for recovering a row that has been inadvertently…
-
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
-
Contact List Functionality in Forms
I've noticed this request a few times over the years, but still don't see that Smartsheet has addressed this. When using sheets, the "Contact List" column works wonderfully and will populate any user within our Smartsheet account when you begin typing a name. However, when attempting to use this within a form, it DOES NOT…
-
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…
-
'Record a date' automation action does not recognize date column
Hi, I have a date column in a sheet (which is used for schedule calculations, so the type cannot be changed); I am now trying to add an automation to fill in this column if another changes and this is blank. However, when I try to deploy the 'Record a date' action, it says that there are no date columns…. How do I resolve…