-
Please Help
I am trying to use this formula- =IF(CONTACTVALUE({Hardware}) = "Andrew Mattos", [Points Bucket]@row - 10, 0)- Basically I want it to search my TR Project sheet for the Hardware column and if it see's Andrew Mattos contact to subtract 10 points from my point bucket column in my data sheet. It keeps coming back Unparseable.
-
Locking Monthly Dashboard Reports
Hi there, I am trying to find a way to "lock" a dashboard so that the reports do not refresh on the dashboard for a month. If this isn't possible are there any suggestions on how to create a monthly report utilizing the dashboard? Thanks!
-
Merged: Parent dropdowns
This discussion has been merged.
-
Mass Uploads and multi-sheet interaction
Hey all. This is likely a stupid question that has been answered before. None of the searches I have done have had quite the answer I was looking for. I am working my way through the core app learning path, but I haven't found what I am looking for. There are what feel like hints of it, but nothing that has clicked for me.…
-
Critical path viewed when linked to a parent row
It would be nice to have the critical path show when linked to a parent row. I have a parent row (e.g. Testing) where the children (e.g. test 1, test 2, test 3,...) are performed in parallel & have the same finish date, so I often link the successor task(s) to the one parent row vs. each individual test task rows (can be…
-
Adding a New Card in Card View Auto Adds to Uncategorized
Hello! In my sheet, I have the card view setup to view by my "Parent" column which is a dropdown column type with a column formula that pulls the Parent task name of my row, because that's what I need my columns to be. When I'm in the card view, and I click the "+" icon in my lane to add a new task, I enter the name and…
-
Why do some columns (fields) not appear in a new form?
Hi, I'm a new user. I created a Smartsheet with roughly 60 columns for a survey form, but not all of these appear when I create a form. Forty-eight (48) of these columns are Dropdown (Multi Select). Each column represents a month of the year for 4 different categories, so that is why there are so many. In other words,…
-
Finding the closest date today with 2 columns of dates
Hi, I am working on a formula to show the next date from 2 rows of dates. I tried =MAX(COLLECT([Release]:[Release], [Live]:[Live], >TODAY())) - and it showed a date from the past. I tried =MIN(COLLECT([Release]:[Release ], [Live]:[Live], >TODAY())) With the same results. Any help is much appreciated.
-
Merged: More Stoplight Colors
This discussion has been merged.
-
Why can I not access the Document Builder feature?
Although I have an enterprise plan Smartsheet account, I have never been given the option to 'generate document', which is really confusing and unhelpful as I plan on using this feature along with the Docusign integration for a current work project. Could someone let me know how I can access this or why I can't access this?
