Hi there, I'm trying to complete my certification and the following nested-if formula needs to be created: "Use a nested-if formula to automate the RYG light in the "Status "column, depending on the "% Complete" for each request If a request is less than 70% complete, turn the Status column "Red" If a request is 70% or…
Hello! I am stuck on the INDEX MATCH pulling incorrect amounts when I reference another sheet. It will work for some cells, but not others. I am thinking since the parent sheet doesn't have all the line item costs for each store such as "Shelving" or "IT/LP", that could be the issue, but not all stores will have those…
I keep getting the above error when I select the 'cog' below the share button. Is this an error only I am experiencing or is this an operational error?c Thanks.
The Barcode scan option has disappeared from my IOS when using a form? Smartsheet recently updated the App Aug 5 however when opening a form I now get a pop up "An Improved experience for this form will be available on newer version of the Smartsheet app" - am I missing something? Code scanner and location drop were there…
Is it possible to change an automated alert email to send from another user or group to that of the sheet/workspace owner? I am the workspace owner and email messages are delivered to customers from me: Can this be changed to a different user or group email account without moving the sheet to another workspace that is the…
hi all I am after ideas to set a tracker for S.M.A.R.T objectives and targets, i have had a browse through some templates but nothing jumping out and grabbing me any thoughts or ideas?☺️
Hello, I am trying to figure out a way to send an alert when a new row is added AND have the automation run at a particular time of the day. If I understand the way the automation is configured, you can choose one or the other. Is there a way to say: If a row new row has been added as of 9am send an alert. Check again at…
Our Intake Clerks input new referrals to be worked up via a form. The insurance department subsequently verifies insurance and inputs the confirmed insurance information in the "Insurance Information" column. We would like to have some real time insight into how long from when a referral is submitted and populating a row…
Hi all, is there a way to access a past version of a grid sheet? One of our files was overwritten by another user and I need to go back to reinstate the original version prior to their change. Is there a way to do this? or do I need to rebuild? Thanks!
I have a larger dashboard that needs editing, moving and deleting many widgets and metrics. Is there a way to select multiple and either choose to move or delete them? Having to it one by one would honestly take me forever.
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
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 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.