-
Tasks due within # of days
Sorry I know this is silly but can't figure out the formula looking at examples. I want a value returned if 'target end date' is due with 7, 15, 30. I have this working but can't seem to figure out how to add the additional criteria to include the other values. The values I want to return are just looking at Target End…
-
Workflow becomes invalid after each trigger.
Hi, I am also facing the same issue. I have set the triggering point to Modified date which is Auto/System Generated Date Column. This is so because my requirement was whenever any changes are done in form, approval request should get triggered. Since we are not sure, what column user is going to change, we kept the…
-
Count of Dropdown (multi-select) items in another sheet
I have a sheet that has a column called Steps, Values Step 1, Step 2,...Step 10 From another sheet, I want to count how many Steps happen in a Stage (which contains a number of Steps) I would like a count formula that looks at the Steps in each Stage and counts how many rows in the other sheet have those Steps in it. I…
-
Max of Children Formula
Hi Formula Friends - I'm trying to calculate the "next test date" based whether a cell is "Surveillance (Monthly)" or "Baseline (Initial)" or "Response (Weekly)". In the formula, it must take into account the following: If Test Strategy in Parent Row = Surveillance (Monthly) or Baseline (Initial), then the Next Test Date…
-
Is the Today function actually being forced to update?
The grid below shows 3 rows. The 1st, Header_Row, is a place holder row for the Today function entered in the 1st cell of the Date.Today column. This allows the formula to be copied down when subsequent rows are added to this Smartsheet. Using automation, the "Delete_Task" row is copied into this sheet from another source…
-
Validate duplicate with 3 variables
Hi guys, I have been working since days in one formula, what I call "cascate formula", to validate 4 variables to define if an event require attention or not. An event can only be validated, if there is NO other event assigned to the same trainer in the same time frame (start and end date). So, I have 4 columns (start…
-
Can you have an Approval Workflow go back into the workflow after a Decline?
Hi! I will try to explain this the best way I can. :) I have a process I need to run through 6 approvers one after another. If one person declines it needs to send an update request to the submitter to ask them to update something. Once that person makes the update I need it to go back to the person that denied it for…
-
"A workflow has become invalid"
"This workflow triggered itself directly or by at least 1 other workflow, which is prevented. Please modify the workflows that are reacting to this one so they don't trigger each other." Greetings all - This may just be one of those "things you can't do in Smartsheet", and I think I've found a work-around, but I wanted to…
-
Recreate a completed task before archiving
Hello! We have a task worksheet that as a task is completed (Done field checked off), the task is archived to another sheet. What we'd like to be able to do is have that same task recreated on a new line before it is archived with the next due date. These are tasks that need to be completed either daily, weekly, or…
-
Adding Cross Reference Formulas
Smartsheet Community: I am not sure what I am doing wrong here, but I am trying to count across multiple sheets when multiple criteria has been met. I think my parenthesis may be incorrectly placed, but Here is my existing formula: =COUNTIFS({Gwen Pas/Fail}, OR(@cell = "Pass", @cell = "Retest Pass")) + COUNTIFS({Rita…
