-
Help fix error with if and formula
I am trying a formula and keep getting an error. Here is what I am trying =IF(and([Billing Status as of 04/10/2023]="Active",[Line Installation Date]@row="N/A"), "Unknown", IF(and([Billing Status as of 04/10/2023]="Inactive",[Line Installation Date]@row="N/A"), "N/A",IF([Installation Year]@row > 1988, "Yes",…
-
COUNTIF with array constant
Hello, Can something like this be done in Smartsheet? Thank you
-
How to get Workday Function to work with Countifs and Cross-Sheet Reference
I'm attempting to count number of blank values that appear in the sheet 7 reference column, where there is a match on the manager, and the next business day from the Sheet 3 reference column is prior to today. This is the formula I'm using: =COUNTIFS({Sheet 7}, "", {Sheet 2}, [Manager]@row, WORKDAY({Sheet 3}, 1) <TODAY())…
-
Symbols
Hi I am trying to add up colour symbols to return another colour symbol. Please could someone help with the formula. For example if 3 greens = green If 2 green, 1 yellow = Yellow If 3 reds or 2 yellows and a red = Red Regards John
-
Adding Date Criteria to formula
Good day- I have a formula that I need to add an "end date". I am not sure that between dates are available? Here is the formula: =COUNTIFS({Gate1Start}, >=DATE(2020, 1, 1), {PPV}, 1, {ItemStatus}, OR(@cell = "Open", @cell = "Closed")) The date portion needs to be BETWEEN 1/1/2020 and 12/31/2020. Right now it is just…
-
Why does the modified date column not update?
Scenario: The sheet contains a date updated column and a workflow is set to automatically send out a request to update specific fields. When the update request is completed, and the date field is edited, the modified date in the report for that row is not updating. Why would the modified date not change if an item in the…
-
Iferror with networdays
I've used IFERROR successfully in the past, but for some reason I can't get it to work with this formual: =NETWORKDAYS(TODAY(), [Request due date]@row, {Holidays}) * 8 I've tried: =IFERROR(NETWORKDAYS(TODAY(), [Request due date]@row, {Holidays}) * 8), "" =IFERROR(NETWORKDAYS(TODAY(), [Request due date]@row, {Holidays})) *…
-
Formula
Hi all, What is the best way to combine each "Catalog" row with a "Status" of new in the Concatenate Catalog? I would like a coma to separate each catalog. Thank you.
-
Formula for countdown symbols
I'm wanting to use the Empty Quarter...Full symbols to act as a clock for when a contract is about to end, but I'm having difficulty with the formula. Hoping someone can help. I have 4 columns: Execution/Begin date, Contract End Date, Total Contract Time, and Days Until End Date. Days until End Date is using the formula…
-
Identify Row with Most Recent Date for a Value with Fewer Cell References
I have a sheet that has reached the cell reference limit and won't allow other sheets to copy rows into it. After doing some research it seems that my column references (column:column) within my formulas are the problem. My sheet contains a unique identifier in the column "ID", and there is a reported date column (we are…