-
How do I track incoming emails in a Smartsheet?
We are getting slammed with inquiries to our info@ gmail address. I think there's a way to send all those emails to a Smartsheet so I can assign, triage, and track our responses.
-
Index/Match? Not sure best function for my needs
Hello, I have a very extensive sales tracker that I use to log charges and calculate the sales rep's commissions based on those charges. The commission percentages change depending on a variety of scenarios, so I created four columns with separate formulas for each scenario. I need the commission column to auto-populate…
-
Track time an item was open (active)
I have a date stamp column already in the SmartSheet. When a new row is added, a date and time are assigned. What would be the best method of tracking and reporting the time duration between when the row was added and when it was closed ? I have ideas but have found it makes most sense to run it by one of you first.…
-
Dashboard reading data from same sell
I want to be able to display the data from the same cell in a sheet within the dashboard The sheet is updated using forms which put new data on the top row, but the value of the cell I had selected in the top row (now the second row) remains in the dashboard, not the new value in the top row cell How do I set the dashboard…
-
Re: Task Alerts
I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I use a form to add new tasks and then included the following columns in my sheet so; * a date column for when activity is due…
-
Sheet count
I have an individual account which allows me 10 sheets. If I decided to delete a sheet after use will that restore 1 back to my remaining sheets???
-
Calendar View & Booking
Hi - our company is looking to hire out a hospitality box in London for a 12-month period that hosts events all year round. We would like internal employees to be able to view the event calendar and to book slots for a specific date where they can then invite their own external customers as well as internal guests. In…
-
Resubscribe user to Automated Workflow
Hi This has been asked in a different way a couple of times. My user accidently unsubscribed to received email notifications. All the community posts say rebuilt the workflow - however, when I try to do that it gives me the following error: "All recipients have unsubscribed from this actions. Enter a valid recipient or…
-
Return Most Recent Date and Other Column Value or Only Flow Most Recent Entry into Sheet per Account
I need to be able to return the most recent value for the Created Date column and the corresponding Discussed column text. Currently, I am using an IF, COUNT, MAX, CHILDREN formula that I found on the community to return a MAX date within a grouping of rows but I can't figure out how to also return the Discussed value that…
-
The new prices have stopped FREE USERs to SEND line of a Sheet
The new policy has change the rules, Free Users are no more able to send line of a Sheet . There are some Workspaces where you can ten or more free user who need that to share. And 120€/users is to expansive now to do it. I send 2 requests to Smartsheet. Support Case Number: 03599177 Support Case Number: 03595187 but no…
