Hello! I am trying to automate the Harvey Ball (R, A, G, Gray) status indicator on my project plan sheet. I am very new to formulas and am not sure what I am doing wrong. Below is a screenshot of the …
I am looking to have a drop down cell called "run name" that when changed will populate all the stores on that run. I was using VLOOKUP from a master store/run sheet to do this but could only figure o…
Hey, I cant figure out how to add to this formula. I have this formula that someone shared from a seminar: =IF(AND([End Date]@row + 1 < TODAY(), [% Complete]5 <> 1), "Red", IF(AND([End Date]@row -2 < …
Smartsheet, Before I lose my mind, here... please tell me that there is (at the very least) a way for individual users to create filters without being shared to the underlying sheet. Up until this cha…
I'm in the throes of building my first sheet and have finished setting up the dependencies and key tasks I need for my project. Tasks are set up by parent/child groups, based on task type. Now I want …
I am trying to create a graph for a Dashboard that will display the total amount of approved $$ within each month and total amount of denied $$ within each month. I will also need a rolling YTD total.…
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to c…
Hi- I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week. I am easily able to plot cost for items that begin …
Hi all, I'm fairly new to smartsheet, and i wanted to know how do i use the "bill rate", ca I change it? How can I access it? I think this is the solution for my issue which is i want to add the costs…