-
Multiple Entries of The Same Name Into A Single Row
Good morning, I am newer to Smartsheet so forgive my lack of knowlede. I have created an attendance tracker form to track employee call offs from for our supervisors. Is there a way for example if John Doe calls off 3 days but each day is a separate submission due to different supervisor working, if each of John Doe's call…
-
Automation change cell value no longer being translated to a $$ value?
Hi, I've noticed this issue in two of my smartsheet processes. I have an automation set up as follows: "When rows are added are changed and [Column A] changes to [Any Value], change cell value in [Column B] to "60" " I then set column B to be $ currency format. Up until recently, "60" changed to "$60.00" without issue but…
-
Issue with Record Date automation.
Hi everyone, I’m hoping someone can help me with an issue I’ve been running into. When a user submits a form late in the evening — sometimes as early as 8:15 PM — the “Record a Date” automation occasionally logs the following day’s date instead of the actual submission date. Originally, I used =DATEONLY(Created@row ) to…
-
How to recover data after I ran a new workflow and lost my data
The black arrow indicates when (around 4:30pm) the mistake was made. I would like to recover a previous version say around 2pm.
-
Merged: Collapse rows for completed tasks
This discussion has been merged.
-
Automation to Auto-Collapse a Row
It would be great if you could set up an automation to auto-collapse a row based on a status or a date that is in the past. I use a grid and calendar to breakdown payroll deadlines and reminders for a whole year and the sheet can get pretty big so having a rule that will auto-collapse rows when something is completed or…
-
Generating document : text not translated in pdf
Hello I’m facing an issue when generating a PDF document from a Smartsheet. The data flows correctly from the sheet to the PDF, but the text is not translated properly, resulting in garbled characters. Example: Value in Smartsheet cell: "TEST" Output in PDF field: "íÉëí" The PDF field is set up as a text field, and it’s…
-
New sheet created from template. Automated workflows being doubled/duplicated.
When creating a new sheet from a template that has automated workflows, the newly created sheet is duplicating each workflow. The result is that when using a template each automation is duplicated, resulting in double row copying, double notifications, etc. This seems to be a new behaviour as our team has been using these…
-
DataMesh Note Section
Within DataMesh it would be really helpful to include an additional field to provide a description of what workspace/purpose etc. that the DataMesh config is applicable to. Currently I have ~50 configs for various workspaces. I have come up with a naming structure however I am limited to how much space I can use.
-
Revert to previous versions of sheets instead of just the activity log snapshot
I just ran automation on an entire sheet instead of just the rows. I wanted to move tasks to a compact task repository, and it moved 364 subtasks that I wish it hadn't. Now, I have to go back and manually revert what I can. Luckily, most of the time, we upload comments and proofs to the parent tasks, which, because they…