-
Weeks/Days Remaining Formula
How can I create a column that displays "x Weeks and x Days remaining" until a task's start date? I know about RYG Balls and what I can do with conditional formatting, but those just aren't sufficient for my needs. In Excel/Sheets I use the MOD function to do this using the following formula: =IF(([Start…
-
Conditional Formatting or Formula
Good Day All: I am trying to use Greater Than Conditional Formatting for two columns. However, Conditional Formatting does not allow you to select 2 columns. Perhaps, I have to use a formula? Here is what I would like to do: If % Complete (Planned) is Greater than % Complete (Actual), then Red If % Complete (Planned) is…
-
Date Calculation \ Automated based upon cell value
Good day Everyone: I have a field set up with automated current date, that is used to calcuate\count the # of days of task duration based on current date and task start date. trying to figure out a way to have Actual duration stop counting once the “Sate” of that task.. reflects “Completed”. Or Actual Duration stops…
-
Flagging when deadline is within 14 days
Hello, To start - I'm not great at formulas, to be honest. I have my SS set up that when the deadline is within 14 days, the date will turn red. When that happens, I'd also like to have my red flag checked. What is the formula for this? Can anyone help me out? Thanks!!
-
Automate Harvey ball color based on multiple variables
I'm not sure if what I want to do is feasible or not so please let me know if I'm going off the deep end. I would like to have a Harvey ball change color based on several criteria/variables to show likelihood the task will, or won't be, completed on time. Has anyone made a formula that will show a red Harvey ball if the…
-
Multiple reference Formula
Greetings: Trying to create a formula that tracks task duration displayed by "symbol" in conjunction with another condition of the task:... complete, or not started. I was able to get the symbols to show up properly based on calculated duration. However, the bottleneck is related to the formula not picking up a symbol…
-
Formula Help
Hello Everyone, I am looking for a formula that will place a number in column B if Column A has a check box that is checked. Thanks in advance.
-
SMARTSHEET alternative to MAX(IF())
Hi, Can anyone assist me, trying to use a simple formula =MAX(IF(Max2418:Max2419 = "YES", [Column14]2418:[Column14]2419)) however Smartsheet says its invalid, I've tested in Excel and it works fine. Just wondering if anyone can suggest an alternative? Simon
-
Multiple Stacked IF formula with OR function
I have got a column called [Status Code] which has a single letter between A-J in it. I then have an adjacent cell where I want to return a specific name depending on which letter is in the previous cell. However I have tried various combinations and cant seem to get it to work. It is nearly there but still erroring. I…
-
If and Formula tracking date, progress with ryg status dashboard
To share back with the community here, I'd like to share some key formulas that I've been helped with by the community and extensive testing/fixing. I have a sheet that tracks: * progress for items based on user inputs of %age complete * compared to the progress they should have completed so far (%age expected as of the…