-
If project status complete - stop calculating formulas & Conditional Formatting
Greetings, Currently at row 1600, waiting for a cell's formula to process the formula may take up to 10 minutes. For instance, sometimes when I change the duration of a Child row by 1 day, it may take 10 minutes for the End Date to advance by 1 day. I use A LOT of formulas, cross-sheet references, as well as Conditional…
-
Embed webpart in a dashboard
Would it be possible to add a webpart to a dashboard? For example, I have a custom map on my ArcGIS online account. I would like to be able to embed a map into a dashboard.
-
Working Days in Dependency Settings with Predecessors
I currently have weekends blocked out in the dependency settings/working days. However If we get behind on the schedule and decide to work a weekend to catch up, how do I add back in a single weekend. I use predecessors to keep the project in the right order of operations. If I manually fill in a date on a weekend and…
-
Approval email work around
Working with clients outside of smartsheet, and I want to send them automated approvals. The challenge I am having is the email address that they are receiving the automatic approval from is not from our business name, or specific user. It is a "smartsheet automation" email. Does anyone have a workaround for this? Any…
-
Can one web form populate different sheets
I'd like to know the following re web forms: One - Can one web form submission populate different sheets Two - Can web forms assign unique ID#.
-
Email based on cell value?
Is there a way to send an email containing the data from a row automatically based on the value in a cell? For example if they choose "Accounting" from a dropdown list or contact list in the "Department" column in row 1, then it would email the data from row 1 to the address on file for the Accounting Department.
-
External URL
How can I make a link to an external url so people can click on the link and it takes them to open up a webpage?
-
Screen blurs for lengthy formulas, or multiple parentheses
Whenever, I try to use if statements or so, the screen blurs and is very irritating to the eye. Could this be fixed ? Example : =IF(AND([Total Man hours]7 >= 1, [Total Man hours]7 <= 16), 1, IF(AND([Total Man hours]7 >= 17, [Total Man hours]7 <= 39), 2, IF(AND([Total Man hours]7 >= 40, [Total Man hours]7 <= 120), 3,…
-
Workspace Notifications - not individual sheets
I dont believe this is possible and if you not i'd like to request this as a feature. Some of my workspaces can have up to 28 or 30 sheets in them, all related to the same project. As the owner i would like to be notified of any changes within these 28 -30 sheets, but dont want to have to repeat the process of setting up…
-
Cell level independence (type)
Hi, Will we see a cell level independence concept soon in SmartSheet ? Currently, we can defined entire row functions and column types but cells are bound by these row and column settings (can't be overwritten) Ex: An entire row can be commented on but no a specific cell. What if we have a column specific data set and want…
