-
How to display Days Elapsed only if Status is Open?
Like the title says, I'd like to only show the number of days elapsed when the status is on Open. I'm currently using this formula: =IFERROR(NETWORKDAYS([Report Date]@row, [Due Date]@row), "") Any tips would be highly appreciated!
-
output data from another reference sheet
I need help in generating a formula for this scenario, please. Our purchase requisitions have to be approved by multiple persons and since we have over 662 department codes it will be awesome if Smartsheet can match the approvers with the department codes and the approval sequence. I need help in generating a formula for…
-
Check for Duplicates
We have a data sheet that we use for tracking requests, and sometimes duplicate requests are entered. I'm hoping to use a formula to flag rows that MAY be duplicates so that they can be reviewed and cleared if needed. For the sake of not over-triggering the check, I'd like to reference multiple columns, namely a "Name"…
-
Table has dates in 7 different columns and I need to compare them all
Background: this is a marketing "push date" table that alerts staff when stuff needs to go out. Each row is an individual event. There is an Event Date column, and the other 7 Date columns key off of that. Any row will never have the same date in any of those 7 columns. There are quite a few rows, one for each event…
-
Percentage formula does not work if denominator is zero
Hi, I have the formula for percentage but when denominator is zero, instead of showing 0%, it does not show anything. How can I make it such that it returns zero if that is appropriate so that my run chart does not look like its missing data points? Thank you!
-
Multiple criteria for If formula
Greetings, Long time reader, first time asking. I'm trying to build a column formula that will return a true or false value based on multiple criteria. The logic is: If [Type1] is ill OR injured, AND [affiliation1] is staff, AND [while working1] is true, OR [Type2] is ill OR injured, AND [affiliation2] is staff, AND [while…
-
How to reference column name pulled from formula
I'm trying to pull a date from columns based on the number in the helper column. I know I can do this with nested IFs, but is there a way to change which column I'm pulling the value from? My column Start Date should be whatever the column is based on the Index. So for the first column below, since Index is 3, it should…
-
How do I reference a variable column name in a formula?
I'm trying to reference different columns based on a value in a helper column. Depending on the value in the helper column, the value should be pulled from a different column. I know I can do this with nested IF formulas, but is there a way to have the column name populated in a formula based on lookup formulas? I wanted…
-
Change Parent row status based on status of child row
Hi Team, Is it possible to that the Parent Status can default or change to Delayed only when any 1 of the Child Task row has Delayed status. Is that feasible through Automation WD or formuale.
-
Conditional Formatting Based on 2 Date Columns, with or without Helper Column
Hi! I've scoured the Community posts, and can't find exactly what I need. I am managing a membership list and need to flag when memberships expire before or on a specific date (06/29/2023) so I can contact those members. I have one column with their membership expiration dates, a second column with the 06/29/2023 deadline,…