Hello, I am trying to sort a report by revenue descending to ascending. The primary column is states. The report automatically sorts by primary alphabetically. I do want it grouped by states but would like to see the revenue from highest to lowest. Any suggestions?
Hello, I'm looking for assistance to try to get this automation to work. I need an Alert to trigger on weekdays only and if the date in the 'Date Approval Requested to Reg Manager' field is 3 days ago. I only want it to remind them once. Is this possible? I used the below screenshot, but it's going to run on weekends.
I have 24 spreadsheets all using the same sheet template with the same columns, but different row/cell values. I changed the name of a column from "BLD FT-CUR" to "BLD FT-JP" on each of the spreadsheets last week. All of the columns have the same naming as the above with no column description and the column type of…
Is there a way to restrict Smartsheet from including the email addresses of everyone in a group to whom a form link was emailed to? In other words, is there a way to prevent the email addresses of everyone to whom the webform link was emailed to, to show up in the "to" field of the received email which was emailed out via…
Hello! I am very new to smartsheet and am trying to learn. My first project on smartsheet for my team is to develop a form that employees will use to check out and then back in an item while at work. I've got the Check Out part done and have it feed to a sheet so that supervisors can monitor who has what. However, I don't…
I have multiple Groups working on like projects with and almost all columns are identical. I want to bring that data together into 1 sheet that I can look at to make sure across the board all items are getting completed. I need the master sheet to get new rows and then update a specific column that is tracking the…
Hi, I am trying to use the formula =TODAY() - [Date Submitted]1 to make a column for {AGE in days} since a form was submitted. I am not the best at formulas but really want to base some automations on days old for sales management and KPIs Like this It works for one row but when I try to convert to column formula like…
Hi, Can you own individual sheets in a workspace if you only have the editor permission level? I am the owner of a workspace and am trying to give ownership of individual sheets to users with editor access but I keep getting the following error message: If I upgrade this user to an admin I am able to make them the owner of…
Can someone assist me with creating a formula that will automatically change the status to open/in progress when a RAID item is added and save to the sheet?
Hi, I have created a logic step where if the form user fills out yes to a question, two extra rows appear. I have tested the form and it works but the additional information appears in the back-end sheet as extra columns. Is it possible for the info to be separated into two different rows rather? We would like the basic…
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.