-
Data for dashboards
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 widgets enabling both the customer and me to make easy comparisons. The problem i am having is regards to the current month…
-
if /or argument
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 am just trying to return 1 if between 50 and 150% and 0 of outside that range
-
Reference the Children of the Parent of a Cell as the Range
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, say Task5 and then specify its "siblings" as the range. I have tried to specify the range as Children(Parent(Task5)), but I…
-
Formulas don't calculate when cell containing formula is linked
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 dashboard. Now it will not calculate and the sheet that references the cell will not be displayed in the fo
-
Using decision symbols to change text
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 'YES' as follows: =IF(Graphic6 = "YES", "Includes GRAPHICS see schedule") but I also want different text "No GRAPHICS" to…
-
Countif formula... using crosssheet formula
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 cancelled, then count all the P1's in the priority column. =COUNTIF({CS Current Months WO status - Status}="Open",{CS Current…
-
Join and Collect Function with Hyperlinks
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(Collect())? =JOIN(COLLECT({Sandbox - DR - Deliverable}, {Child SKU}, =[Child SKU]1, {Sandbox - Delivery Readiness Tracker Range…
-
Hybrid Report/Sheet
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 additional columns (i.e. with formulas to display graphics based on whether the assignment was completed on time) or additional…
-
Harvey Balls Automation
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 was hoping to get some help putting the nested if statement together. Here are the conditions I am working with and a…
-
Dependencies for drop-down menus
Hello, How can I create a drop down menu dependent on value selected on the previous drop-down menu? Thanks Laura
