-
Formula to Calculate the Number of Work Days a Task Took
Good morning, I am trying to figure out the number of work days between the actual start and finish dates. The formula =Finish@row - Start@row is giving me the total number of days. Example: Start date = 03/07/2022 Finish date = 03/31/2022, the answer is 24. Whereas the workdays would be less. The formula…
-
Records 30 days or Older
I am new to Smartsheet stiill. But I need to write a simple formula that calculates the number of records that are = or greater than 30 days old. Based on the Initial Escalation Date and Today's date Using Networkdays The Status must be = Open
-
How can I consider multiple Columns within criterion range from collect formular
With the follwing formular the criterion ist just in one column of the reference sheet: =IFERROR(INDEX(COLLECT({NBR 2023 Standard Sets - Input Orders Clie Range 5}, {NBR 2023 Standard Sets - Input Orders Clie Range 9}, CONTAINS([Indiv. Set No.]@row, @cell), {NBR 2023 Standard Sets - Input Orders Clie Range 6},…
-
Move rows (workflow) change sheet destination when saving as new
Well, this is the context: I have a project template folder in a Smartsheet's Workspace that includes some sheets and reports that I use in my projects. The problem that I have right now is that I created a workflow for the project plan sheet that when it's triggered, it moves a specific row to a sheet called "On Hold…
-
Move rows (workflow) change sheet destination when saving as new
Well, this is the context: I have a project template folder in a Smartsheet's Workspace that includes some sheets and reports that I use in my projects. The problem that I have right now is that I created a workflow for the project plan sheet that when it's triggered, it moves a specific row to a sheet called "On Hold…
-
Need a COUNTIF of "% Complete" cells that are either blank or less than 100%
I just can't figure this one out. Any help is appreciated.
-
IF formula stops referencing columns after a certain point unless I manually type
I have a survey going to to people with 56 compliance rules. When the survey answers as "out of compliance" I have a rules column for each rule change that to a "1". Another column I've made have multiple selection options with the rule number and compliance issue. So Ideally when someone answers "out of compliance for…
-
Creating Formula from a linked sheet
Need Help. I have two sheets- Sheet1, has all the Survey Values (i.e, Yes, No, NA), and Sheet2 will have all the Formula. I want to assign a numerical value on the answers of Sheet1. For instance, Yes= 15, No= 0, N/A =0, and have them all populate in Sheet 2. So here is my formula in Sheet2 =IF({Sheet1} = "Yes", 15,…
-
Need to verify SUMIFS formula - Incorrect arrgument set
=SUMIFS([Diagnostic]:[In Progress], 1, [Start Date]:[Start Date], IFERROR(YEAR(@cell), 0) = 2022) Want to sum values in columns Diagnostic, Disc and In Progress where the date/year is 2022. The columns are in this order - Diagnostic, Discovery and In Progress. With 1 or 0 values in them. I need a sum of all these 3 columns…
-
If statement based on date paired with Smartsheet Symbol
I have a sheet that lists due dates in one column, and I was wondering if there is a way to use an If/then statement within the symbol column to indicate the following: If the due date is within last 12 months, the symbol is green If the due date is between last 12-18 months, the symbol is yellow If the due date is longer…