-
Broken link on the Project Intake Sheet in the PMO Template set.
Hi, I have seemed to delete some of the links on the Project Intake Sheet on the PMO Template Set. How do I restore the links.
-
Auto fill a second column based on a drop down selection using a form
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates into a sheet. (This seems…
-
Cross-Sheet MATCH INDEX ERRORS
I am running in circles trying to solve this issue - seemingly, in using MATCH() on an external cell reference, the value it returns caps itself at 14 even though data goes out to ~30. While I end up using this base function in much larger equations, the screenshots explain the basis of the issue: Here is the Cell…
-
How to compare form responses with a list of emails?
Hi! I have created a survey/form and emailed it out. One of the survey questions asks participants to enter their email address. How can I compare their responses to the list of emails I sent the form to? I would like to create a report that shows who has responded and who has not based on the email addresses.
-
Dashboard Image Based on Data Value
Is it possible to display an image on a dashboard that is dependent upon a value in the cell of a sheet (not including the existing symbols within Smartsheet) and can change as the value changes? I have a sheet with a variable that can have 3 possible values. I'd like to show the value on a dashboard as an image rather…
-
Reduce clicking, allow user to edit all sheet and sheet summary formulas at once
I feel like I'm clicking endlessly... 👆️👆️🖱️Double-click to open the cell formula 👆️👆️🖱️Double-click to highlight the part that I need to edit 👆️👆️🖱️Double-click to open and edit the next cell... My hand hurts. It would be great to have some sort of edit pane that allows me to edit all formulas on a sheet at once. Or…
-
Merged: Form to Modify Existing Row
This discussion has been merged.
-
Making sheets from a sheet
I know how to copy info from one sheet to another sheet. My question is...I've created an Application form for my employees to fill out. Is there a way to set up where a new sheet is created for each applicant and copies their info to it also. Meaning...Joe Smith fills out my application - then Smartsheets creates a brand…
-
Clean up reference sheet labels
I've searched how to clean up reference sheet labels within a task sheet when creating formulas, and I can't seem to find anything. It gets unruly when I'm creating formulas in multiple columns. Thanks for the help! Linda
-
Within X amount of time from Today
Hello, I am trying to find a formula that will tell me if a date is within 4 Years of today's date and populate "YES" or "NO" in a separate column. (Example: To help specify if a product is in warranty that lasts 4 years, and populate "Yes" in another column if the date entered is within 4 years)
