-
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…
-
Formula errors
* Schedule Variance:* Getting errors Invalid & Unparseable. * My best guess to those results. Are the other columns that it's looking at have cells that are blank. ( actual finish date) resulting from the fact that that task is not completed yet. Thus nothing to draw from * What I’m trying to have the formula pick up...is…
-
Count ifs?>
Hello, I created a form and now have all the data i need. However My formula to give me the number of each tea that was voted for has to be accounted for. It seems that my countif formulas are not working correctly. Can anyone help me?
-
Keep users from back-filling completed dates
is there a way to set a date column so that only the current date can be entered? Right now we have START, DUE AND COMPLETED DATE columns. The problem is that people are back-filling the completed date, for example putting in a 3/1 completed date on 4/1. We would like to get people to fill in the completed date on the…
