-
How do I sum something when I'm looking for multiple names in a cell
=SUMIFS({MASTER - Payroll Entry Log Sheet Range 1}, {MASTER - Payroll Entry Log Sheet Range 2}, "005 - Service","005A - Service (San Antonio)
-
Find the Percentage of the Total
Hi! I have 4 columns that I have added together in the 5th, Total column (using =sum formula). Each of the 4 columns is a single dropdown select (values: 1-10). I want to translate the Total into a percent in the Percentage column, so I thought if I took the total value and divided by 40 (the max amount) in the % column, Iโฆ
-
Nested IF/AND Formula
I'm receiving an #UNPARSABLE error for the following formula: =IF(AND([Completion Status]@row="Completed", [Actual End Date]@row<=TODAY()), "1", IF(AND([Completion Status]@row="In Progress", [Actual End Date]@row> TODAY()), "2", IF(AND([Completion Status]@row="Not Started", [Actual End Date]@row> TODAY ()), "3", "4")))โฆ
-
Flag is true when status is not complete and date modified is 5 days old
Hello, in an effort to automate update request emails for items that have been stuck at a specific status for a period time, I am trying mark a flag as true when the row status is not complete, and the date modified is more than 5 days old. I think I need an IF And formula and having difficulty incorporating the andโฆ
-
IF/AND
Hello, There may be a more efficient way to solve this so please feel free to suggest an alternate way. I have a column in my sheet that collects the time/date a form is submitted using the "Created - Date" field option . I need to set up an automation that would be triggered by the time the form was received AND the dayโฆ
-
CountIFS and Summery Date Field
Having trouble with the following formula returning an "Unparseable" error. =COUNTIFS(Type:Type, "Release", Status:Status, "Complete", Due Date:Due Date, >=[Current Quarter Start]#, Due Date:Due Date, <=[Current Quarter End]#) Can anyone provide some help?
-
Use only parent rows in a referenced sheet
I'm trying to count the number of times a text string is found in a different sheet in columns of the same name, but I only want to count if the name is in a parent row of the referenced sheet. The formula below is #unparseable. What is wrong with it? =COUNTIF({Sheet1 Names}, CONTAINS(Names@row, @cell), {Sheet1 Names},โฆ
-
Subtracting Dates
I have 2 date columns in my sheet. When I try to use the NETDAYS function I get #InvalidDataType. Does this function work with date column types? What am I doing wrong? Incidentally, the Created column has a formula to lookup the created date.
-
How to convert USD to Canadian Dollars format in Smartsheet ?
Please help me to figure how to convert USD to Canadian Dollars format in Smartsheet ? Also, does it depend on user setting or sheet settings?
-
Using SUMIFS with YEAR and MONTH from single referenced column
Hi all, I'm trying to create sheet that will sum up all revenue for a year, by month. End result should look something like this: I'm using this formula and receiving an #INCORRECT ARGUMENT SET error: =SUMIFS({anrev}, {vehicl}, "Site", {Scale Date}, IFERROR(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 1) (this is forโฆ