-
Feature Request: Programmatically access parent information from child in automated messages
A lot of the users consuming my automated alerts complain that the tasks don't have enough contextual information. For instance, "start marketing research" doesn't include the parent information of "Awesome Campaign #3". Need a way to include parent information in automated messages. For example, "Hi {{Assigned To}}! The…
-
Best Formula
I have a construction schedule with start and finish dates. I want the check boxes for the at risk column to automatically check off if the project is late starting or late finishing. Can anyone help me craft the appropriate formula for this? Is there a good formula for this? I was thinking it would be an if then formula…
-
VLookup - Multiple Searching Criteria
Hi all, I am struggling to find a way that allows Vlookup to search with multiple criteria in two columns. Referring to the screenshots - On the worklist sheet my aim is to VLookup into the Forms Testing Sheet and the criteria be both the agent name (Row two on the Worklist) and The Week Numbers above (Row one on the…
-
Automate [Actual Finish] based on when [% Complete] reaches 100%
I can't trust taskees to update [Actual Finish] reliably, so automation seems to be the key. I want to automate [Actual Finish] based on when [% Complete] reaches 100% I have really tried to bang my head through this, but to no avail. I keep running into endless updates of [Actual Finish] or #CIRCULAR REFERENCE issues.…
-
Countifs with AND/OR
Hi There I have a Countifs that is counting the number of projects that are healthy (Green), marked as "prioritized", are "in progress" and match a particular category. This works great, except I'm trying to expand this to look for "in progress" projects OR "not started" projects, but maintain all the other AND criteria..…
-
If statement % complete column
I want to create an if statement in my % complete column such that % complete goes to 100% when another column has a date.
-
IF and OR Formula
Hi, I am trying to write a formula that returns a flag if one of column 1,2,3,4,5,6,7 isn't checked. I have tried using the IF and OR formula together but am getting #Unparseable. Any ideas/help will be appreciated. Thanks
-
Drawing row linked data into another sheet together?
Hi All! So I have a sheet with a list of tasks, a checkbox for completion and a due date. In one of my other metrics sheet, I am trying to generate a list of my top 5 overdue tasks. I have managed to get a list of the most overdue dates with a SMALL(COLLECT...) function which will only count dates that are not listed…
-
Calculation Formulas on Reports
Our company uses Smartsheet a little differently than most but I am finding it would be very helpful if I could add formula calculations directly to the reports I pull. Currently I have to add the formulas to the sheets themselves, hide those columns and continue dragging formulas down as we add rows. Hundreds of sheets...…
-
Formula Refers to Worng Row
I have a SmartSheet that was created with nothing assigned to the primary collumn. This means many email notifications have no reference to what row or item it refers to. So, I added a formula to concatenate other collumns into the primary: =ID1 + " - P/N " + [P/N or Item #]1 + " " + Client1 + ", " + [Short Description]1…