-
Help with nested If, Then Statement
Hi, I inherited Smartsheet templates from a staff member no longer with the organization and am trying to understand the formulas driving our metrics and dashboards. A column formula was written to generate schedule risk as follows: The sheet columns: Can someone please help me understand the logic in plain speak? I want…
-
Formula using the RYG status balls
I'm trying to write a formula using the RYG status balls. These are the criteria: Green= If the "Deployment Complete" box is checked Yellow= if there is a date populated in "Module Go-Live Date" Blue= for anything else (deployment is not complete and Go-Live is not scheduled) I only got this far with the formula and (of…
-
Need to check a box if any of these are true
Hi, I'm trying to check a box if Sales Status equals either "Deployment Prep Call - Scheduling", "Deployment Prep Call - Scheduled" or "Verbal Agreement" The formula works for one of the three choices: =IF([Sales Status]@row = "Verbal Agreement", 1) However, I'm getting an INVALID DATA TYPE error when I have all three…
-
How to Consolidate Entries from Multiple Forms
I've seen this question asked before, and the same answer is always given, "use an update request." Is there a way to consolidate information, because I don't think update requests are the best solution for our process. I have multiple forms with different types of information being entered at different times by different…
-
Nesting multiple IF statements inside OR statement
-
Reassign Contacts with Automation
Our accounting team regularly reassigns projects to new managers/staff and I need to find a way to automate the change once a date has been reached. In the example below I would want the contact to change from Joe to Jim once the Estimated Transition Date has been reached. The problem is I need this to be a 1 time write…
-
Formula issus while automation
Hi All, I am currently having an issue for one o my workflow, I will try to describe briefly: I have a ticket system that we use for one customer. Whenever a ticket is completed in the "Open ticket sheet" by our Team, the line is moved to an "archive sheet" thanks to an automation. In the open ticket sheet, I have this…
-
Subtracting Dates to determine what is less than 90 Days
Maybe I need to use a different formula, but this was successful in returning "Short" for everything, rather than anything under 90 days. We are trying to call out short start projects or those that require less than the average 90 days, so a difference of 90 or over should return nothing. =IF([Anticipated Activation…
-
COUNTIFS & AND + <>
Hello, I appreciate your help in fixing this formula. I want to exclude from counting any blank cell for one column & any cell with "Center" from another column. The one for excluding "Center" is not working. =COUNTIFS(AND([Deliverable(s)]3:[Deliverable(s)]137, <>"", [Responsible Party]3:[Responsible Party]147,…
-
All Dates populate based off one date
Hello, I am trying to create a sheet where I can put in one date in the Target Start Date column then all other dates populate from that date based off the duration it takes to do all the task. Is this possible?
