-
Date Last Updated?
Is there a formula I can use that would show the last date that a specific column was updated? For instance, when someone checks the checkbox column, could I have a formula in another column that would reflect the date the checkbox was checked? It wouldn't work to have a formula that showed when the entire row was last…
-
#INVALID OPERATION in my nested IF statement
Hi there Community! #INVALID OPERATION has me beat today. I believe the issue is somewhere in the bold area bc when I pull that section out I don't get the "#INVALID OPERATION" error message. The error is only displays when the row meets the criteria of the last IF statement ("Occupied"). When the logic is met for the bold…
-
SUMIFs not working in Smartsheet VS Excel
I have the following table in excel if i use the function =SUMIFS($C$2:$C$5,$A$2:$A$5,101,$B$2:$B$5,"Approval") it will return the value of the approval date - 1/1/2020 however when i do this in smartsheet, the formula returns a blank. Does anyone have any thoughts here? Alternatively - would anyone have another solution…
-
Cell in child row display value from parent row (but different column)
Hi, I am having issues getting a formula to work to show the value from a parent row in a child row when the parent row value is from a different column. For the example below I would want a formula for the Associated Project column to always show the parent name in from the Project column. Thanks!
-
Countifs and OR statement
I'm trying to have a formula that will work if one column matches specific criteria and then if another column matches one of two criteria. I have been able to get it to work for one of the criteria from the second column by writing =(COUNTIFS({Assigned Owner}, [Assigned To]2, {Project Progress}, <>"Closed")) However,…
-
If a cell does not contain a period
Looking for the syntax for if a cell does not contain . (a period) This is not working =IF([Work #]1 <> "*.*", "No", "Yes")
-
Formula to populate a cell from 1 of many populated columns
I have 5 columns. Only 1 of the 5 will ever be populated per row I need help with a formula to populate a cell with the value of the column that has a value. I tried =([Cell1]@row+[Cell2]@row+[Cell3]@row+[Cell4]@row+[Cell5]@row) It seems to work but it gives me a leading zero
-
Baseline/Actual Schedule formula help
Hello all, I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additional rows with "Actual Start" and "Actual Finish". When I enter dates into those rows, I'm looking for them…
-
Nested VLOOKUP statement error
I am receiving an error with the following nested VLOOKUP statement. I've included an image that might help to better explain. Unfortunately, I have looked at this so many times and tried so many combinations that I'm afraid it is a simple fix that I am just not seeing. Need to use the number in Details4 cell (in this case…
-
Nest an IF Formula
With the help of the community, I have two formulas that I would like to combine into one if possible. Formula 1 =IF(Ancestors@row = 0, COUNTIF(Ancestors$1:Ancestors@row, Ancestors@row = 0), "") Formula 2 =IF(LEN(RowID@row) = 1, "000" + RowID@row, IF(LEN(RowID@row) = 2, "00" + RowID@row, IF(LEN(RowID@row) = 3, "0"…