-
Manually Adjust Automated Logic - Status Colors
Hello, I have a full project list that I've added a formula for project status for red, yellow, green, and blue. These are all linked to the phase of the project and the start or finish date. The only issue I have is if the project is known to be at risk or failure but the date is still in the future. These need to have a…
-
Separate Automations from Safe Sharing
At this time, Safe Sharing also restricts automation emails to only the emails added to the safe list. https://help.smartsheet.com/articles/855284-security-controls-enterprise-only Wishing we could separate this: We have use cases where we do not want to share a sheet with a 3rd party, but we still need to send them…
-
Hello, when a form a is created, is there an option to save and submit later?
-
Lookup from another sheet
Is there possible for smartsheet to automatically lookup the list of materials description in materials index sheet in my releasing monitoring, Currently im using dropdown for releasing monitoring and manually copying the list of materials description from materials index, which is way too hassle cause everytime ill add…
-
Add data filtering to Data Mesh
Please add a capability to include a filter when defining a Data Mesh. It can be a pre-existing filter from source sheet, such as is available when creating a dynamic view.
-
SUMPRODUCT - Need help
Hello all, I'm looking for finding a workaround of the excel function SUMPRODUCT Below an example : Where you can see 16% the formula is : =SUMPRODUCT(F14:F46,E14:E46)/SUM(E14:E46) In advance thanks
-
Account unknown on different device
This discussion was created from comments split from: Log In.
-
What happened to the ability to make an admin of a sheet an owner?
I am an admin in a shared workspace that my client else owns. I often create Smartsheets for him and then once approved, want to transfer ownership of the sheet I created to him. There used to be a dropdown next to a person's name in the Sheet Sharing settings where I could select make owner. Now that is gone. It is…
-
Calculating Hours and Travel Time
The above screenshot is from a time report that I would like some help with. The Total column calculates all the columns in the row, the final column calculates the Total PAYE. The Total PAYE formula is as follows: =([Travel To Site]@row - 0.75) * 1 + [Std Hrs]@row * 1 + 1.5 * [OOH (1.5x)]@row + 2 * [OOH (2x)]@row +…
-
How to edit an existing row through a Smartsheet Form (Not an update request)
We have an automation that pops up a smartsheet form for our sales agents. They speak with customers multple times. We'd like to use the form to edit existing rows (Not create new rows). The Update Request Workflow solution does not work for our specific use case. Is there any way to accomplish this?
