-
Displaying multiple column values in Calendar view
I am storing data related to issues in the smartsheets. How can I show the issue number and priority in the calendar view?
-
Requiring Approval when Dates Change
Hello community - I currently have an approval request enabled that notifies me via email once a day whenever a date in the Due Date column is changed. I also have a dashboard that shows me whenever an approval is needed and would like to eliminate the emails coming in to advise me. Is there a way to set up a column that…
-
T-shirt size icons for visual icons?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
-
Data Matrix for dashboard - cross sheet formulas
I have created extensive data matrix's to calculate # of Jobs and dollar amount for individuals in our company to track capacity. However, as our sheets get larger, the formulas wont calculate. I receive an error message reading: "Some cross-sheet formulas cant be updated, because this sheet has more cells referenced from…
-
Flag if Multiple Dates in Same Column
I'm attempting to set up conditional formatting to highlight cells if there are duplicate dates in the same column. (For a spreadsheet managing event bookings, want to highlight if multiple requests for same day) I tried an IF/COUNTIF function in a new checkbox column but I keep getting #UNPARSEABLE. - Column name is Mtg…
-
Standard Emails
Hi all, Been looking but cannot find an answer. I am using SmartSheet with a rental property I have. I want to send guest the information on the property a week before they arrive. I have set up a date field that is a week before check-in. I can see using that as the trigger, but my email appears to be too long and also I…
-
Salesforce ServiceCloud Users/Connections
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…
-
Nested IF & Multiple arguments
Hey there! Currently trying to automate a tracking report that my company uses. I want the "District" column to automate based on the property number entered. However, while there is only 7 districts, the list of properties could easily be in the thousands. We can determine the district of a property by the first two…
-
Automating R/Y/G/G Formula for some colors
Hello - Is it possible to create a formula that only looks for some of the colors in the R/Y/G/G drop down column. My drop down order in the Stage column is Not Started, In Progress, Completed. In my Status column I have Red, Yellow, Green, Gray. I am looking to create a formula that enters a 'Gray' icon when 'Completed'…
-
Supplier Management - Template
Hi, I cannot find a pre existing template in smartsheet templates Do any smartsheet users have an existing template on their smartsheet account for Supplier/Vendor Performance or Evaluation, preferably with pre defined criteria, and pre formatted score chart and graphs? If so, are you happy to share this template? Thanks
