Hi all, Is there a way to change the color on a gantt chart view while utilizing it on a dashboard? I tried to change them from the report but I can't seem to find the option. Maybe I'm thinking that …
I know this is probably a longshot, but it'd be really awesome if Google Sheets would enable us to have both Google Sheet tabs and Smartsheet tabs (with Gantt chart capabilities fully enabled). Right …
Hello, I have the following formula that does not seem to be working. =IF([Result]19<0,100%,IF((AND([Result]19>=100%,[Result]19<103%)),100%,IF((AND([Result]19>=103%,[Result]19<106%)),75%,IF((AND([Resu…
Hi all, I searched and I didn't find anything for this so I am hoping I did not just miss this. We are trying to tie our data into Microstrategy for more visualization options. We are using the Live D…
What replaces/is equal to the "row function"? I am trying to look up data with various criteria and array those multiple matches into separate cells? Using the article and formula below, I tested it i…
Firstly, formulas will be the death of me. My coworker wants to to do this- If the overall plan is 25% complete and 25% through the duration = green If the overall plan is 50% complete and 50% through…
I have a form that users will be submitting whenever they remove an item from the Supply Room. The form will capture which item was removed, the quantity removed, and who removed it. I am capturing th…
Hi, Can anyone please suggest with a "month to date" formula that I can use in my sheet that is set up as shown in the attachment? I have a column that lists down all the dates in the year 2020. I wou…
Hi - we get two-halves of requests from separate parties, and I'm using DataMesh to link to things based on a Unique ID. Once the second half of the request is in the sheet, I don't need to update it …
I have an interesting scenario where I am combining 3 SmartSheets into 1, and this happens in three phases: First, someone initiates a request by submitting a request through a form into the first Sma…