-
Alert someone Workflow - Company Group Email Address
Through our company Outlook, we have a few group email addresses. When an email is sent one of these email addresses it distributes the email to the people who are set up in the distribution list within Outlook. Since you cannot alert a Smartsheet group within a workflow (I've submitted an enhancement request already!) we…
-
Form with formula INDEX/MATCH
Hello! I'm trying to see if this is possible. I'm creating a calibration form, but I'd like a specific task duration to be tied to each item, which then populates the due date. For example: Each piece of equipment has a set duration (ie. 365 days). This would be hidden on the form sheet. Once a user submits the form, I'd…
-
Form logic in the mobile app
I searched the forum for an answer to this but I could not find one. I started using the new form logic feature recently (great addition!). When I open my form in the app on my Andriod phone the logic does not work but it does work on my iPad. Am I missing something?? I verified my apps are the most recent update.
-
Is there a way to see how many people have viewed a PUBLISHED sheet?
I can see through Activity who has viewed the actual sheet, but can't find anything on how to see who has clicked into the published sheet link.
-
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…
