-
Formulas
I am trying to write an IF statements that allows me to set either an up, sideways or down arrow based on the the difference between two dates. I have found many example and have tried to reverse engineer them however I am not having any luck Basically if the two date fields when subtracted = a number less then or = 7 then…
-
Nested IF for Numbers with Greater Than, Less Than, Etc.
Hello SmartSheet Community! I am trying to get a number that has it's own formula in it, to then be the number that is done in another formula on another cell in the same sheet. I'll go over this to ensure there is no confusion about what I am doing. ====================================================== First, my nested…
-
Formula for only Children rows but excludes Parent rows
Does anyone have any ideas or a sample formula where a value can only be applied within a column to rows that are of children level? So essentially, if its a parent row it doesn't insert any value within the column, but if its a child row it populates that same column with a value.
-
Embedding IFERROR into an existing formula
I need some help as to how to embed an IFERROR function into this formula: =IF([Group Contract Anticipated]438 = 0, "Gray", IF(ISBLANK([Deposit Due Date]438), "Gray", IF(ISDATE([Deposit Sent]438), "Green", IF(TODAY() - [Deposit Due Date]438 <= -10, "Green", IF(TODAY() - [Deposit Due Date]438 > -7, "Red", IF(TODAY() -…
-
Help with RYGB Formula Logic
I can't seem to get this formula to work properly, and my eyes are crossed now. Would someone be willing to take a look to see what I'm doing wrong? =IF(OR([% Complete]21 = 1, Complete21 = 1), "Green", IF(ISBLANK([Start Date]21), "", IF(AND([End Date]21 >= TODAY(), Complete21 <> 1), "Red", IF([Elapsed Duration]21 > [%…
-
SUMIF using a cell with a formula in it
OK, so my formula is this: =SUMIF([Customer PO]:[Customer PO], [Customer PO]2, [Value to be invoiced]:[Value to be invoiced]). I'm pretty sure it's correct, but the 'Customer PO" column uses a VLOOKUP formula which I think is what's causing a #NO MATCH error...? Is there any way to get around this?
-
Reference Entire Column in Function
Hello Team, I wish to reference an entire column in a function, for example: Current Function: =SUMIF([Task Owner]1:[Task Owner]82, "Text", [Resource Sum Column]1:[Resource Sum Column]82) / 100 Desired Function: =SUMIF([Task Owner]:[Task Owner], "Text", [Resource Sum Column]:[Resource Sum Column]) / 100 Is this possible? I…
-
Formula for Summary of Total Tasks and Completed Tasks
There is a smartsheet template set in the solution center called New Employee Onboarding. In the sheet "30 Day Employee Onboarding Sheet" the tasks are organized by Week and By Day. The formulas for counting Completed: # of # are working for each day, but the Cells that have a Weekly Total are not summarizing for the week,…
-
Match Formula with another sheet
I am having difficulty with this formula that I would appreciate some assistance. I have a sheet with user names. If the user name matches that of a user name in another sheet, I need to select the checkbox. I have a column with a checkbox and the following formula: =IF(MATCH(Name1, {2019-01-11 IS Bi-Weekly Report Range…
-
Current w/c date
I need a formula that will return the date of Monday for the current week. So on Monday 08/05/2017 it will show 08/05/2017, but on Wednesday 10/05/2017 it will still show 08/05/2017. Please help!