-
Gantt Chart bars - different colors to distinguish
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've used it under the calendar functionality and getting confused. Can someone confirm?
-
Integration + Feature Request: Google Sheets with Smartsheet Tabs
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 now we can transfer the data but none of Smartsheet's Gantt chart functionalities are transferred.
-
IF Function Condition - UNPARSEABLE
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([Result]19>=106%,[Result]19<109%)),50%,IF((AND([Result]19>=109%,[Result]19<112%)),25%,IF([Result]19>=112%,0%,0)))))) For every 3%…
-
Microstrategy
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 Data Connector. Has anyone been able to successfully integrate Smartsheet and Microstrategy? If so, I'd like to speak with…
-
Use a Lookup to Return Multiple Matches?
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 in excel with my data and it worked.....I just cant translate here. Can you use the example below as the demo when showing…
-
Formulas will be the death of me-
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 the duration = green If the overall plan is 75% complete and 75% through the duration = green If the overall plan is 100%…
-
Link to sign out after form submittal?
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 the "who" by forcing the user to log into Smartsheet when they access the form link. However, there is no way for them to log…
-
Month to date formula
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 would like to insert the formula in the checkbox column such that if the criteria is month to date criteria is met, the box…
-
DataMesh - Updating ONLY new lines
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 again. Right now, my DataMesh setup is updating that row anyway - is there any way to ignore "old" or existing requests?
-
Combining Dates For a "Sort By Date"
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 Smart Sheet. When they submit the request, the request is simultaneously copied over to a "Master Sheet." When it does this, it…
