-
Filter for Current User with multiple contact column
I have created a sheet filter "my todo´s" for the current user. This works if only one contact is entered in the filtered column. But we have enable multiple contacts for that colum. Is there a possibility to build a filter "contains the current user"?
-
Can a dashboard be exported to a Google slide deck?
I would like to take parts of a dashboard and roll the data into a preestablish Slide deck
-
Document Generator from multiple rows into one Document
Can I select multiple rows to a single document to "Mary": Name item Qty Price Mary 1234 01 $10.00 Mary 2345 02 $35.00 Mary 3456 01 $90.00 Mary 4567 10 $ 5.00 Also, will the document generator create multiple pages based on text wrapping? Thank you,
-
Forms Workaround: Submit button opens new form to allow sub-info - How do I stop when user is done?
Please help! I'm stuck. Goal: Create a form customers can use to report a problem with an order. The order may have more than one line item (i.e. Customer ordered 5 received 3 of product #1-ABC and ordered 3 and received 5 of product #1-ABE, both on same order) I want the customer to be able to provide their contact…
-
Hiding form drop downs based on prior submissions
I'm trying to mimic a Qualtrics survey capability that enables the survey (form) to only show available dates that have not already been selected by prior survey respondents. Is there a way to accomplish this?
-
COUNTIFS functionality for multiple entries
New to SmartSheet and I promise I have been looking around for an answer, but without any luck so I thought I would throw it out to the community... I am looking to sum up all entries in column in a summary total at the top of my sheet, but the formula I have is only calculating where the searched for text is alone in the…
-
How to count At Risk task to create a report?
Hi, I'm using a template and it already allow me to flag a column when At Risk. I would like to count how many items I have flagged, but i'm not sure how. I've used =SUMIF({Sheet - Request Tracker with Form Range 1}, "Red") =COUNTIF({Sheet - Request Tracker with Form Range 1}, "Flag") Thanks for your help
-
Between Dates Formula Referencing Another Sheet
I have two sheets I am trying to tie together. Here is the scenario: Sheet 1 (Below): Has the city reference. Current Rent is where I am trying to type the formula. Idea is to return the current rent based on today's date and the city. Sheet 2 (Below): Has the rent schedule range and the city to reference. There will be…
-
Calendar Display Column
How can I change which column is displayed on my calendar?
-
Modified report based on when comments were added
I am trying to figure out if it is possible to either create a report or even have the modified column updated based on when a comment/attachment was added. Right now, the modified default only updates when someone updates a cell in the row itself. Please let me know if you know a way around this. Thanks!