Hi i am looking for some help with some dashboard data. I would like to display data from a sheet that shows all data captured (YTD) and also current month data. This will be displayed in two metric w…
Sorry to bother with such a simple question, but what is the problem with this? =IF(OR([Average 6mths]7 * 1.5 > [Current Monthly Usage]7, [ Average 6mths]7 * 0.5 < [Current Monthly Usage]7), 1, 0) I a…
I'm looking for a way to auto number my WBS. I believe I have found a way using logic functions combined with the Match function. The issue I am running into is that I am unable to reference a cell, s…
I have a sheet that totals the row values when a row is added from a form. It worked well until the cell containing the formula was linked using vlookup to a separate sheet that is the source of a das…
Please can somebody help me, I'm new to formulas! I'm trying to get text in a cell to change depending on what decision symbol has bee selected (YES, NO, HOLD) I managed to get it working with just 'Y…
I've tried both... they don't work they say unparseable... what am i missing I want to I am looking to add up all P1's that have a region of America Break Fix and a status that is not finished or canc…
Hello All, I got my function to work the way I wanted it to, but it did not keep the hyperlinks when it gave me the values. Is there a way to keep the hyperlinks or add them back when using Join(Colle…
I'd like to use Smartsheet to track performance on a multitude of projects. I can use a Report to quickly gather a list of assignments and compare Need Date to Date Completed. But I can't add any addi…
I am trying to put together a formula to automatically change the RYG harvey balls based on the end date(due date) and the completion status of the empty/quarter/half/three quater/full harvey balls? I…