-
Automated Workflow Not Working
I set up a simple workflow. Once someone writes their initials in a column, it should move the row to another sheet. Except it is not moving the row to the other sheet. But when I look at the activity logs from both sheets, it says that a row has been moved from the source sheet and the destination sheet says a row has…
-
Parent Formula to display modified child status
I am looking for a Parent / Child formula to capture a status change (R / Y / G). The Parent status will change based on the Child status Change. For example: If I change the status of "Software" to Red (R) in the child row, it should change the Parent status to Red. The parent row captures any child row that changes from…
-
Multiple forms with unique dropdowns
Hello, I currently have a smart-sheet that gathers data from multiple vendors (each vendor has a form). One of the columns is an ID which would be entered through a drop-down. The functionality we are looking for is to have unique drop-downs for every form. Would this be possible? When I plug in the values for the…
-
Automated emails
Hi, Is it possible to change the "from" address when sending automated alerts/update requests? Or is it always the default SmartSheet address? Thanks
-
Conditional links on forms
Hi, New to Smartsheet, is it possible to link fields on a form based on conditions i.e: - If user selects 'Production' from the field 'Employment Department' then mandatory that must select a 'Production Shift' (i.e. one of following Green,Purple,Red,Blue,Yellow) - Else if 'Employment Department' ≠ 'Production' then…
-
CountIF with Criteria including date range
Hello, I'm currently trying to create a countifs formula to count the number of "issue type"(column) "story" where it meets certain criteria including falling within the next 30 days. My base formula works here: =COUNTIFS([Issue Type]:[Issue Type], "Story", Labels:Labels, "Groomed", Status:Status, "To Do") However, when I…
-
Managing Testing with Automation Waterfall Notification and Showing Status with RYGB Balls
I have spent some time looking for solutions to my specific need but have been unsuccessful to find anything that fits right, although there were lots of good suggestions that I tried (and couldn't make it work). We are migrating servers from one location to another and we have multiple IT groups that need to test the…
-
How can I automate a subtraction
Hey, How can I subtract a number from the total each time a row is added. I have an Inventory sheet that linked to another sheet. for example, in the picture below; how do I subtract a Number of Machine each time a row is added? Thanks in advance.
-
How to build bar graph of submissions by user
We are using Smartsheet to build a Change Management process for our IT department. The way it currently works is we have a form that users fill out containing all the details of their change request, which are recording to a spreadsheet. I'm building a metrics dashboard for this, and am trying to determine a way to build…
-
OR function Not Working with Multiple Logical Expressions
Hello, I have the following formula: =IF(OR(Status4 <> "Complete", Status4 <> "Sent/Complete"), "not complete", "Complete") which always returns "not complete", i.e. true. However, modifying the expression so that only 1 logical expression is present, the expression works correctly, showing the true and false outcomes as…