-
Workflow - Add a condition to Move Row / Data Shuttle move instead of delete
So, I'm trying to write a workflow that will move rows not updated / added from a Data Shuttle import. I've added a custom expression that adds a helper column with a "1" if the row is added or modified. That part works great. Moving the rows not touched is the problem. I created the workflow below which I'm now learning…
-
Dashboard creation from Portfolio Metrics sheet
Hi everyone, I am trying to build a dashboard of metrics and charts, I discovered that it is easier using data from sheets than from report and summary reports. I came across portfolio metrics as source sheet for dashboard - I am thinking it was created by linking cells from different sheets. How can I go about creating…
-
How to Mask Circular Reference and Blocked Errors?
I have a SmartSheet that I have that references a Cell that calculates employee capacity. I created two cells that reference it, one is a point value, the other is a cell that calculates the percentage of the Employee Capacity cell. Employee Capacity -------------------> Action / Task Hours <---------------> Percentage of…
-
how to chart datas over a period?
Hello Everyone, I am struggling to find a way to chart this data, where I got hours of each resource required for each project. Trying to chart total number of hours of each resource over a period, lets say for the next 3 months of project lined up. I am at a stage where I can only be able to chart them per project of each…
-
Unhide comments & attachment in front first column
Hi community, I was trying to unhide the comment and attachment icon before first column but couldn't find a way. Is there any way that I can unhide only comment and attachment? Thank you.
-
Problem changing cell value to checked
Hello, I have a question: I set an automation for when the value of a cell equals 'Submitted' or 'Resubmitted' and where the value of 5 other cells say 'Approved' a check box should be checked. The automation setup in my mind is: When X happens, and meets Y condition, do X I do not know why, but I am not able to get the…
-
How can we have a google drive folder link used as an attachment to a Smartsheet form?
Hi all! We are implementing a new Smartsheet form and our offices submit this form and need to attach multiple files. Seems there is a limit to how many files can be attached to the form. We were thinking our offices can submit their files by sharing a link to the google drive files on the smarthseet form as an attachment…
-
Automation Not Allowing Alerts to Contacts in Specific Fields + Form Not Adding Lines to the Sheet
Hello, I have a 2-fold issue with my Smartsheet. I'm setting up workflow automation, and it's only allowing me to alert one type of contact. See below. I am trying to also add an alert for the registration member assigned to the project. Additionally, I submitted a test form submission over an hour ago, and it's still not…
-
Moving data from row-level attachments into SS rows.
Hello! I recently received a request to build some form of "batch upload" process, where users upload a spreadsheet filled with contact data and submit it via form. We would then like to move the data from these row-level attachments into columns on another sheet, where contact information from all form attachments is…
-
Replace value if overdue
Hello, We have a sheet to track teams and supervisors that we update weekly with new hire employees. Each "seat" is it's own row, and to show team size, empty seats are labeled as "Open Spot." If we have a new hire coming in, we put them with their projected team and projected start. On their start date, the other cells in…
