-
Enable/Disable automation workflows across multiple sheets
My use case: I attended the PM workshop at ENGAGE where a lot of sheets had Automation workflows set up. I would wake up to about 20 unread emails because of these workflows. The only way to stop the email was to individually disable each workflow in all of the sheets. This feature would also be useful if I am looking to…
-
Reference Reports in Formulas (e.g. VLOOKUP) to sheets
It would be so nice to use a VLOOKUP to reference a report and pull what I need back to my sheet. Unfortunately, sheets can only pull from sheets.
-
Notes section on Sheets
It would be great to be able to have notes or a text box area on a sheet to put information that the team may need to see or know about it without having to attach the comment to a field on the sheet or making a dashboard. If a text field could be added where the calendars are or a new widget that would be great.
-
Edit Start, End, or Duration from Report
I'd like to be able to edit the Start Date, End Date, or Duration of a task from my report. At present I can only edit Start and Duration from a report because End is treated like a formula. This is problematic when I need to adjust both dates because it forces me or another user to do math (accounting for non-working…
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
Change "end date" based on status changes
When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies…
-
Make Formula Window Adjustable
The formula window at times blocks the cells users want to quickly reference in their formula. Can this window be adjustable or can a formula box be added to the UI?
-
Update Reports using the API
I found an old thread in the community about this, so mayn users are looking for it a long time already. I need to be able to update reports using the API, most importantly I want to add or change the source sheets of a report using the API. In my current case I have multiple reports using the same sources and if a new…
-
Sync my Outlook calendar to Smartsheet
I want a function to reflect the events in the Outlook calendar in Smartsheet and publish the Smartsheet in the Calendar view. I manage sales training schedules, and some training are recurring ones. I use Outlook Calendar to schedule training and invite salespeople. I want to sync my Outlook calendar to Smartsheet and…
-
Please Add a Sum Product Formula
Please add a sum product formula to improve ease of calculations without workarounds.
