-
Time with fractional seconds
Good morning, I am using Smartsheet to track swim time which has a format of minutes:seconds:fractionalseconds (i.e. 5:00.50). I would like to see if anyone has a solution for a couple of issues I am seeing: 1. I would like to use the MIN function to look across multiple cells (swim meets) and pull the minimum for the…
-
Rollup text to parent based on MAX of another column *SOLVED
Hello- This is a look up of sorts. I have a list of files. Each time i receive the file it is logged with it's package name and date. I can MAX CHILDREN the date and it rolls up to the PARENT, however, I cannot figure out how to have the package name of the max date rollup. Any assistance is appreciated!
-
Checkbox question
Is there a way to have a checkbox automatically checked if other columns with checkboxes get checked? I have 4 columns with checkboxes and instead of doing value columns for each one I would like to do a summary checkbox and just value one column. If that's not possible, can you set values for more than one column?
-
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?
-
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,…