-
Create Weekly Alert on a Dashboard
Hi, I want my Dashboard to display a specific message every Monday and a different one every Thursday. I tried searching the community but didn't find anything. I used the following solution. Is this correct? It seems to work. Any other idea? Thanks I created this on a metric sheet=IF(WEEKDAY(TODAY()) = 2, "Remember the…
-
Does locking a column in the destination sheet prevent cell links from updating?
Hi All, We're encountering a problem where cell links are not updating. There are numerous project sheets (a few hundred of them) that each have a set of cells linked into a master sheet. When the owner or admin of the sheets makes an edit in one of the project sheets, the master sheet receives the update via the cell link…
-
Sort report by revenue
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?
-
3 Day Reminder - Automations
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.
-
Renamed a Column, Now Column Header Showing Twice in Reports
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…
-
Prevent the email addresses of group members to show up in the "to" field of the received email
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…
-
Can a Smartsheet Form Show information from a sheet?
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…
-
linking data from multiple sheets to a master sheet
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…
-
Convert Column Syntax Error
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…
-
Can 'Editors' own individual sheets in a Workspace?
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…