-
Need a column to auto populate the month NAME when the date column next to it is selected.
What I need: When final complete DATE is entered, the final completion MONTH column lists the month associated. For this example: 11/15/24 was entered in the Final completion DATE column. I need the final completion MONTH column to auto reflect NOVEMBER.
-
How to create a single notification when Data Shuttle workflow is run by schedule?
Hello! I created a notification triggered by "complete" status of a column, but the sheet is is fed by Data Shuttle workflow that is set to run every 15 minutes. As a result, I received a notification every time the sheet was updated based on the workflow frequency. I need to create a single notification, when the column…
-
Auto Populate Cell Reference by field names
This is going to be hard to explain, but I'm hoping I can do it. I have a sheet named "ProjectSheet". Under Task Column I have multiple "Applications". Under each Application is a Project Stage (Data Gathering, Build, Post Go Live). Under each Stage are two roles (IC, IE) (Top - image) I have a second "Team_Dates" sheet…
-
Multiple IF statements
Hello, I'm trying to make an IF( formula for the following criteria. If Tech is YES and Curved is YES, 650 If Tech is YES and Curved is NO, 500 If Tech is NO, 0 Thank you!
-
Automation Not Sending Emails
Hi All, I have a sheet with "Unrestricted" automation settings; however, I'm getting an email with an error message that people aren't receiving alerts due to permission settings. Any ideas?
-
Grouping in reports should stay in place when emailing a report
When making a report and organizing data by groups within the report, these groups should stay in place when sharing the report via email. I tried making a report for HR on employees' attendance and scheduling it at the beginning of the month for the previous month. Was then surprised when the email came in with a raw…
-
Reports - Send as Attachment - missing Group and Summary
I use the Send as Attachment function to update several leaders in our company. I have tried the PDF and XLS versions but have a problem. All off the Grouping and Summaries in the report are stripped out. Is there a way to generate the Send and keep the Group and Summary data?
-
Change Formatting in Reports
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
-
How many would be interested in more visual customization in sheets?
A primary use case for Smartsheet for my department currently is what we call Selection and Segmentation. Essentially we crunch a bunch of data about influencers in a particular field and match this data to the goal of a company we consult for. We then suggest a pool of candidates for the company to focus their efforts on…
-
New Templates?
Hi Smartsheets Crew; I wanted to know if you guys are going to create any NEW Templates in your Solution Area OR 🤔 If you plan on ENHANCING / ADDING to your EXISTING ones (to utilize any/all recent changes to the software) since the Template(s) was launched? 😁 It would be great to see some fresh new ideas that relate to…
