We are trying to automate a price sheet from an outside system using the data shuttle. We pick up the file from OneSrive and map it to the target sheet in Smartsheet, this is where we are stuck. Is there a way to keep the crazy formulas we have created for all the tiers and discounts without having to manually log back…
Hi, I am trying to set up a workflow for change cell when Complete is checked, status updates to 'Completed' but after setting this up saving and refreshing nothing happens when Complete is checked. Regards, Anthony
Hi, I suddenly noticed that the dashboard is messed up after I made some changes in the source sheet. It shows just dots and messed-up figures such as in the attached snapshots (capture4 and capture MHT4) vs the correct one capture5. What could be the major reason since I've only made minor changes such as updating the…
Why user getting unexpected error during single sign-on after MAC BigSur upgrade? We have tried the following: Have cleared cookies Using Google Chrome Have logged out and back in Was able to log in fine before MAC BigSur upgrade
I'm trying to create a notification if two cells do not match each others values. We currently would need this is a production environment where a PO quantity is created and as the item is produced, if the department doesn't log the same quantity as the PO, the notification is sent to the supervisor. For example. IF PO…
I have several columns representing different categories. Each category have multiple selection. I need to show in one cell all the name of the categories that are not blank. I don't know what formula to use or if I need to create reference table first.
Is there any update on when reports might keep the grouping/summary rows when sent as an attachment or displaying on a dashboard? I remember hearing this was 'in the works' back in February.
Is there a way to share a folder in a workspace without having to share the entire workspace? If not, is this something that could be reviewed as a possibility?
Hello, Community! I've seen a few posts but not getting this. I want the Status Indicator column to be: Red: if Current Status = Delayed Yellow: if Current Status = At Risk Green: if Current Status = On Target Blue: if Current Status = On Hold/Deprioritized I need help, please!
Scenario: I have created a sheet template that we use for all projects which has about 6 reports(Late Tasks, Next Tasks, At Risk task etc) and one dashboard that are associated with that one sheet. Is there way to create the reports and the dashboard automatically once a new sheet is created off the template and have those…
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
How can I customise an update request in a workflow, so that the updater has fields that are required to be updated before submitted the update?
Help shape the future of Smartsheet. Share your ideas and feature requests.