-
Lock or Store Date/Value Solution without using Zapier
Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it…
-
Average / Collect referencing another sheet and a date range
I'm trying to average the ticket ages for the current month. I’ve tried several formulas and currently I’m trying this: =IFERROR(AVG(COLLECT({SourceEOMCaseAge}, {SourceIncludeEOM}, "Yes", {SourceClosedMonth}, "April", {SourceClosedYear}, "2024")), "") The formula needs to include ticket ages where the closed date is blank,…
-
Change Cell Value workflow: Include symbols
Use case: When a new project is created, we want the initial project health to be a green symbol. The Change Cell Value workflow does not include Symbol type columns, only text/number, single select drop downs, and checkbox columns. Can we include Symbol columns in this workflow as an enhancement?
-
MAX COLLECT for blank cells
Hello all, we use a Smartsheet form for students in our internship program to submit their weekly hours worked for our instructors to track. Because the form creates a new row for each submission, I created a rollup sheet using MAX(COLLECT() to show all submissions on a single row to make it easier for our instructors.…
-
Select if multiple update request are acceptable.
Why not have a selection for multiple update request OK? We have sheets that get updated when information becomes available. But once you use the link and submit button for Update Request, you can not use it again. Our teams would like to use the Open request and submit multiple times for updates when they come available.
-
Automatically Sort Rows in Sheets
As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.
-
View Cell History in WorkApps
We should be able to view cell history withing WorkApps. I'm very surprised this isn't currently possible!
-
Remove or Suppress Blank Rows in Report
Hello. I have a report that is displaying 15-20 rows of data (will never exceed 25 rows). The problem is that the report appears to default to showing 50 rows regardless of the data. As a result, in the current state, there will always be between 25 to 35 blank rows on this report. I am looking to use this report on a…
-
Group Rows in Sheet, not just in Report
I would like to view rows grouped by their category (from a dropdown column) in Sheet form, so that I can add new rows while viewing my data in an easier-to-read format. Currently it seems grouping can only be achieved in a Report which does not allow me to add new rows. I am new to SmartSheet but have intermediate…
-
Fully customized automated emails
Is there a way to better customize automated emails? Backstory: We have an intake form where our users are able to enter a ticket for our team. We want to provide some transparency and a view to that request - status, priority, etc - without giving them access to the sheet itself because we have a ton of working columns…