-
AVG Collect Divide by Zero error
Hello, I am stumped again. I am looking to average data from another sheet and am getting a #Divide by Zero error, even though I believe the formula is written to ignore zeros and blanks in the data. What am I missing? =AVG(COLLECT({Indirect Project Summary -Avg Leadtime}, {Indirect Project Summary - Executive Sponsor},…
-
AverageIf not returning correct value
Hi all. I am working with a sheet trying to get what - I thought - would be a simple average, but the formula seems to be returning the incorrect value. I am trying to get an average of the temperature in a column if the created date (created date is the Smartsheet default column) is equal to yesterday: Which I would…
-
How do I show a risk register in the dashboard
Hi, I need to show a risk register in the dashboard that only shows high risk activities, how can I do this? Every time I try, it says the data I am trying to show is incorrect and that I need to select different data. Thanks
-
Schedule Data Shuttle for a Specific Day of the Month
Unless I am missing something, it appears that you are unable to schedule data shuttle on a specific day of the month. I have a monthly report that comes on the 10th that needs to import into Smartsheet. It appears the only way I can make sure data shuttle catches this is to run it every single day forever. There is a lot…
-
Smartsheet for Slack and Microsoft Teams now generally available in AU and EU Regions!
February 11, 2026 Smartsheet’s integration with Microsoft Teams is now available for all users in the AU and EU Regions! This will enable users around the globe to collaborate where they work, moving projects forward seamlessly. Learn more. Environment Availability: All Plan Availability: All Subscription Model…
-
Report that looks like a Form
I would love to see a report that looks like the form that was built.
-
Is there a way to include the Sheet Name as a variable in a message?
Based on this KB article (Dynamically Add Cell Data in the Subject and Body of Request Messages) I know that we can include the names of columns (like {{Name}}), but I want to update the subject to include the name of the sheet itself (like {{Sheet_Name}}. Context: We have created a contact list template, that has a form…
-
How would I add in a month based off a date in another column
Hi, I am needing to create a column that will display the correct month based off a date in another column. My columns are below. I am not certain on which formula to use. Thanks for the assistance!
-
Cell-level Comments
Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads "Cell" next to the "Row," "Sheet," and "All" tabs. Currently, I'm spending a lot of time describing columns and going back and forth on communication to confirm columns and which…
-
Dynamic View does not allow anyone to change and save specific column
I have a column with a dropdown list. The column is restricted to listed values, and you can select more than one. There is no logic assigned to that column in the dynamic view, and is not listed as required. I've tried disabling the conditional logic on the sheet, and it did not correct the issue. This is happening to…