-
Form questions
Im new to forms. I am trying to setup an "entered date" that defaults to the date the person makes the request and cannot be changed. The date field does not have a "today" button and no information about how this is done. This should be incredibly easy to do...
-
Average formula
Hi, Can you suggest me with a clever way of calculating average for a group of cell references? Please see attached screenshot of my sheet. Anytime the data for a new month is entered into my sheet, I need to manipuate the average 6 months formula so that calculates the average for the latest 6 monthly only. Is there any…
-
Webinar recording available: Top 5 tips for optimizing your sheets
Missed the webinar? Review the recording in the Smartsheet Learning Center. Top 5 tips for optimizing your sheets. Learn best practices for getting the most out of your Smartsheet, including sheet structure, collaborating in a variety of ways, and tips for focusing on what matters most.
-
Expense Report Ideas
I am trying to build an expense report sheet for external attendees that come to trainings. Is there a way to allow them to submit each expenses separately through a form but then somehow automatically group rows together so that we are only paying each person one time for multiple expenses? These people will only attend…
-
How to count how many times a word appear in multiple cells?
I am trying to count how many times a word appear in multiple cells from a different sheet. I am using =SUM((LEN([Column6]2) - LEN(SUBSTITUTE([Column6]2, [Part Number]@row, ""))) / LEN([Part Number]@row)) and it works if I look just for one cell, but if I try to count from two cells appear Invalid type data. Anyone?
-
Recurring Reminders
I set up indefinitely recurring update requests. Currently, I have to manually delete the update request when I receive the requested information. Is there a way to automate turning off a recurring reminder? For example, if I have a "date information received" column, is there a way to have the recurring reminder deleted…
-
How do you create a report that counts the number of each status on a sheet?
How do you create a report that counts the number of each status on a sheet? I want to create something similar to this template but with my actual statuses not these preset ones. How can I either change this report or create a new one? When I tried to create a new one my report builder looks completely different.
-
VLookup's in Smartsheet - Are there limitations?
Does anyone know if Smartsheet has a threshold limit on the number of VLookups that can be used within one sheet? I have 7 columns with a max of 300 rows of data in a Target sheet, I am wanting to run VLookup's with to 3 different Source sheets and I want to make sure there's not some crazy limit that says your formula…
-
Automatic Reminders
I am a little confused and unsure if I am configuring this feature correctly. I have a Smartsheet with a Contact, Status, and Entry Date columns. My goal is to have a reminder automatically sent, beginning on Entry Date, and then every three days thereafter, if the Status=In Progress to the Contact listed the column. Do I…
-
2 questions: Reminders/Alerts & Dates in a contacts' calendar possible?
When we set reminders/alerts it goes out as an email. Is there another option for the reminder to appear a a pop up as in outlook? Also, if we have a contact column and a date column, is it possible for the dates assigned to certain contacts be imported in their outlook calendar? And then they could have a reminder that…