-
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…
-
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.
