-
SUMIFS pulling data from another sheet and applying criteria of a date range
Hello, I have scanned through previous posts and could not find one that matches my situation. I created a Metric Sheet which I want to pull footages from another sheet that fall within a date range. I followed the formula syntax and ensured my headers are correct and the format for date range is also correct but I keep…
-
Dashboard chart colors changing
This discussion was created from comments split from: Dashboard Graph Widget - Color in Series keeps changing.
-
WorkApp Sharing Difficulty
I am attempting to share my first WorkApp with collegues who have licenses. I have published them but not informed them that they have permissions. I have learned from them that they cannot see my created WorkApp on their WorkApp landing page. I am missing something. Do I need to inform them via the system with a…
-
Recall/return feature
Hello, I have a question about Smartsheet functionality. My university uses a form submission software for purchasing reconciliation that has a return/recall feature. From what I understand, Smartsheet does not have a comparable native return/recall feature. The closest equivalent Smartsheet offers is the an update…
-
Change Terminal Automation Actions to Non-Terminal
I suggest changing terminal actions such as the "Record a date" and "Change cell value" actions to non-terminal actions. There are many times when I would like to record a date or change a cell value before the next action in the automation occurs. Having separate automations for these actions and ensure the proper order…
-
Copy/Paste retaining formulas with multiple sheet & summary field references
This just may not be possible, but no worse off if I ask. We have a 'table' of data constructed of cells with formulas using sheet references, and summary field references. We are trying to consolidate our metrics into one central sheet for easy annual/quarterly updates as they are used across multiple dashboards. The…
-
Allow for Smartsheet to pull and return column names into a formula
Unlike some other spreadsheet programs, Smartsheet formulas cannot reference the actual header row (row 0) as data. I have a sheet which tracks many dates pertaining to our projects. Each column is named for the relevant milestone. I built a column formula that can iterate over those columns and pull the most recent date…
-
Limit date field in Forms to today's date OR a future date.
-
Forms: Contact List Default Setting Current User
When adding a contact list field to a form. I have noticed the need for an option of current user as a default setting. Some forms are repetitive and require an email often times that of the user filling out the form. This would greatly enhance the form experience and optimize user time.
-
Reports API: Full CRUD Support Now Available
You can now create, read, update, and delete reports programmatically via the Smartsheet API. Reports are no longer UI-only — they're a first-class API resource, just like sheets. What's new The Reports API now supports the full object lifecycle: Create reports from API calls — no more manual setup in the UI Read report…