-
multi-select column not appear in report grouping
Why does a multi-select column not appear in Row Report grouping options in Smartsheet, and what is the recommended workaround?
-
Brandfolder API: surface search parameter syntax in /assets endpoint reference
I'd like to suggest a documentation improvement for the Assets endpoint reference. The search query parameter on GET /brandfolders/{brandfolder_id}/assets is currently documented generically, with no indication of what can actually go inside it. The fact that you can filter by custom fields (custom_fields.{key}:"value"),…
-
Count the number of unique dates in the Created date column
Hello, I'm trying to write a Summary Field formula that will count the number of unique days in the Created date (titled Date Added) system column without using a helper column or metric sheet. I am able to get the correct total, and the list of dates counted, when I use the Analyze data AI Tool: However, I'm not having…
-
Data entered on a Report doesn't trigger VLOOKUP based on the underlying Sheet cell contents, Why?
I have a VLOOKUP set up to pull a date from a cell on Sheet 1 to a cell on Sheet 2. The date will only populate on Sheet 2 if it is entered directly on Sheet 1. Filling in the same cell of a Report based on Sheet 1 does not populate the date to Sheet 2. I have instructed users to interact with the Report for ease of use…
-
Why is my Level Code formula erroring on just level 2?
I'm trying to produce a WBS. I used the helper columns and formulas from the Smartsheet template set. The Level Code formula works on all but the 2nd level (purple) which shows #NO MATCH. Expectation: First purple line should read 1 and second purple line should read 2. WBS works fine if I hardcode those values. Anyone…
-
How to recover lost data from a sheet
I made a mistake and end up deleting information from one of my sheets, but now I cannot find a way to recover a previous version of this sheet to recover my original file. I need help to fix this, and it seems Smartsheet is really lacking this recovery feature for everything I'm reading and checking online. Any help or…
-
Absentee Calendar/Log
Good morning, We have an absentee calendar for approximately 150 employees, including 30 supervisors. Supervisors absences must be notified to a specific group. Automation works well for single day absences, but when an absence spans multiple days, the supervisor is not consistently included in daily (Mon-Fri)…
-
Sheet automation notification email tracking using a PowerAutomate Flow and Outlook
This post details how to track all sheet automation notifications emails. This solution is medium complexity and will likely require you to use an AI for some simple coding. Smartsheet allows users to automatically send email notifications from sheets. There are a few significant problems with these automated emails.…
-
Has anyone been able to get the Claude connector read write permissions?
How did you do this? I have had a support ticket in since the beginning of last week. It is still unassigned and I can't get my Smartsheet rep to respond to my inquiries.
-
issue with simple countif formula
on a sheet i have summaries which should count if month numbers in a column. it works on other sheets but not this one so am a bit dumbfounded. the "month" column is a formula (=month @ row) basically telling me what the month was the shipment was created. the summary is simply count records for each month.…