-
Lookup to return multiple rows
I have a sheet containing invoices for all projects (one invoice per row). I'd like to have a separate sheet which returns all the invoices listed against a single project code (with each invoice still on its own line - basically a filter with the criteria set by a cell reference). Is there a lookup which can do this? A…
-
Is this available as a template?
This is offered as a free resource if you sign up for a trial and we are already a customer. I would like to use this and build off of it: https://www.smartsheet.com/sites/default/files/2020-08/IC-Vendor-Risk-Assessment-Questionnaire-Sample-Form-10878_PDF.pdf Thanks in advance!
-
Recovering deleted proofs
I'm sure there are others in this community in the same boat, but a colleague accidentally deleted an entire proof instead of just the version, and there is no way of recovering it (this isn't the first time this has happened). I called the 24/7 Smartsheet hotline and unfortunately they don't have the capability to recover…
-
How do I only move most recent record to my Open Ticket Sheet?
I receive a daily ticket report and I am looking to use Smartsheet to keep a list of the most recent data for each ticket. I am not the best at using formulas so I would love for some help. In the picture it shows the column headers for both my sheets I am trying to work in.
-
Possible to add hyperlink to confirmation message after form submission?
Is it possible to add a hyperlink to the confirmation message after the form submission? Ideally, I would want to give the user an option to go to another form and/or dashboard.
-
True/False IF formula not working?
I noticed that the formula I was using wasn't working so I moved it to a text column to see if the output is correct. Turns out the output is giving me 0, so no wonder the checkbox isn't checking! My issue is that I'm trying to get a checkbox to check if the values are either -5 or 5. However, I'm stumped on what I'm…
-
Dashboard: filter outstanding tasks
Hello there, I need to show in my dashboard all the outstanding tasks (status ≠ closed). I'd like the graphic below (metrics section) to represent an overview of the open tasks. In addition I'd like to prepare a graphic with the workload per user, in order to see the open tasks assigned to each employee. Please enlighten…
-
different thank you messages based on a selection in the form
Hello, we want to send different Thank you message with diff information based on the selection the users make in the submission form. We have an event and the replies are Attending Declined TBD Based on the response, we need to send different thank yous, because we want to provide them with different information. is it…
-
External form
***Translated by a Moderator via Google Translate as the Community is only supported in English*** Hello, when I create a form, is it possible to send it to a person who does not have a SmartSheet “license”. Someone outside our organization? Merci,
-
Are you able to change the third line down on a conversations email?
When someone is mentioned in conversations, is there a way to change the row it refers to (in this example: Row 40: Admin Lead QC - Prior to Technical QC) This is a task name I have added, but I am wondering if there is a way to change what column this feature picks up? Thank you, Alicia