-
Formula for checkbox column
Hello, I need a column formula that check marks all the children rows if the main parent row is checked. Thanks!
-
At risk flag formula help (please!)
Hi there, I am attempting to enter a formula in a flag column to automatically show at risk (red) when tasks are overdue and not 100% complete AND when due date is within 7 days and the %complete column is not 100%. Attached is a screenshot of what I have taken a stab at, I am not amazing at multiple condition formulas so…
-
IF formula issue (again)
I though this would be an easy one but it has me stumped again... So i now want a column to populate with a symbol based on an other columns status to give a pictorial representation of that status, is this possible? i.e. The symbol option used was from the 'Status' section and was the empty circle running through to the…
-
Formatting Charts
Hi all, I am trying to make a chart that references a report, and I have been successful in capturing the avg, and count values of groups I made inside the report. Where I am having trouble, is that I want to change the labels of the Legend. The legend pulls the name of the column it is referencing, however it is…
-
Formula Error
Hi Community, I needed to adjust a formula to perform an OR function instead of an AND function and now I'm receiving an error that I can't seem to correct. The issue lies in the first section of the formula to produce a "green" value if true. Any help would be greatly appreciated!
-
Dollar values keeping the comma delimiters
I repurposed the formula to this below. Now I have a range from 10's of thousands to 100's millions. how do I not get that final comma next to the period automatically? ="$" + LEFT([Unit price]@row, IF(MOD(LEN([Unit price]@row), 3) = 0, 3, MOD(LEN([Unit price]@row), 3))) + IF(LEN([Unit price]@row) > 3, "," + MID([Unit…
-
Summarize tasks for assigned teammate on an intake tracker
Hi there - I am not understanding how to use this COUNTIFS formula above. I am in the process of creating a SmartSheet dashboard for my team from an intake tracker we have. I would like to use the metrics widgets which require sheet summary formulas. Problem - I am trying to create a sheet summary of how many current tasks…
-
Multiple IF ANDS criteria
Hello! I'm trying to write a function for 3 criteria with if ands, "Approved", "Not Approved" and "Pending". Not sure im using if and correctly. It's a document approval process which requires 5 individuals to review a document. I want the status of each document request to be shown per individual and then have the overall…
-
Comparing dates IF/AND
Hi, I am trying to create a formula for: If Date1 is less than 2/29/2022, then cost for the month is Feb2022 at row value. If Date1 is greater than 2/29/2022 and less than 3/31/2022, then cost for the month is Mar2022 at row value. Formula below isn't working: any help on what I am doing incorrectly is much appreciated.…
-
Help with a formula that I need to return the result of Green for 2 reasons
Good day: I have my formula mostly figured out (see below). I want the result of green if my % Completed is 100 or if the End date is >15 days from today. How can I accomplish this? =IF([% Completed]@row = 1, "Green", IF(ISBLANK([End Date]@row), "Blue", IF([End Date]@row < TODAY(), "Red", IF(([End Date]@row - TODAY()) <=…