-
What is wrong with this formula?
The following formula appears in one of our Smartsheets as a column formula: =IF(Holidays@row <> "", IF(TODAY() >= Holidays@row, COUNTIFS({Course Complete Date}, Holidays@row, ""), "")) This formula had been functioning as intended for quite some time, but it started yielding an #INCORRECT ARGUMENT SET error a few days…
-
Adding days to a Date to determine a future date
I am trying to create a formula that will look at the date within the row, look at the frequency and then determine what the next date will be. I am using the following formula: =[Estimated Date of Charge]@row + [Frequency in Days]@row Here is the result: The system is just populating the date in the Estimated Date of…
-
trying to convert a row to column formula using IFERROR
using NETDAYS to calculate days between dates, and an IFERROR to have Blank populated. This works in the row just fine, When I try to convert to a column formula, I add @row to the cell and it becomes #UNPARSABLE. Before adding @ROW tried to convert to column formula and get the following. Help!!!! formula that is working…
-
Need a second pair of eyes on this formula please
Ok, I'm going crazy. I have used this formula 3 times already on my roll up sheet and it's working just fine, but suddenly I'm getting an INCORRECT ARGUMENT error. I've been staring at formulas all day...am I missing something here?? =COUNTIFS({Program Schedule - Shell Mobility pt 4 Range 1}, "Stage 2", {Program Schedule -…
-
Calculate Average Time
Hi Team, I have one sheet that calculates the time duration that a tech is onsite per line, but what I need to do is in another sheet calculate the average time TOTAL for all entries. I'm having trouble figuring out how to accomplish this. Thanks in advance for everyone's assistance!
-
CountIFS - last month, current month and NOT cancel
What am I doing wrong? This is my metrics sheet and I want to count if - last month has a date in the completed column and does NOT has a cancel status. I will need one for each last month and the current month.
-
CountIfs Formula - INVALID REF
I am attempting to do a COUNTIFS formula with a reference to a different sheet. This is the formula =COUNTIFS({Archived Review Responses_EMPLOYEE Range 3}, Community@row, {Archived Review Responses_EMPLOYEE Range 4,"1"}) If I use only the first criteria in a formula, which would be: =COUNTIFS({Archived Review…
-
Formula that can be applied as a Column Formula that marks unique values/entries out in a list
Hi All - I have a sheet that has a list of URLs in one column - lets call that column [HIRE URL] Some of these URLs are duplicated and I am looking to use a Helper column to mark which ones are unique entries. I found this formula in another forum post which I adapted to my needs; =IF(COUNTIFS([HIRE URL]$1:[HIRE URL]@row,…
-
Pulling a Rating from a Matrix
I have this data in a Smartsheet file (exported to Excel below) and I need to pull a Risk Rating from any of the nine combinations of two variables. Thanks in advance for the help!
-
I want to count the number of times values appear in a multiselect column
I am not sure how I can combine INDEX MATCH, HAS, and COUNTM functions for me to be able to count the number of times different values appear in multiselect fields