-
How can I send a reoccurring email with an embedded link to a survey form?
Hello All, We currently have a survey form that we send twice a week to our team of 20 plus employees. We also have a helper sheet that uses formulas to gather this information into the statistics we want to share. We currently do this manually through gmail, copy and paste the link every time. I am looking for a way to…
-
How to make the symbol show instead of the word in a form
Hi, I'm working on form entry for a survey and I'd like them to rate in a star system. I'm able to change the column type to symbol with stars, but in the form the selection is word based (one, two, three, etc) instead of star selections. Is it possible to make this change? Thanks, Liz
-
Modifying rows in a form entry sheet with formulas
Hello everyone, I have a problem when I change some date in rows in my sheet, here is the example : A user fill information in a form, and then a new row is added in the sheet related to the form On that sheet, there are a lot columns that have pre-defined formulas I have put the new form entries parameter on the top of my…
-
Conditional Logic on Forms
Hi I currently have conditional logic on forms that is working as I expected. I have a type that has Risk, Action, Issue I have additional columns for a) Description, b) Related Risk, c) Related Action d) Related Issue, e) more information, f) file upload Using conditional logic, I set up the rule, Type = Risk show a,…
-
Sync a column change in multiple reports
I dont think Ive seen answer to this, but I have multiple reports in the same format that are used to separate different sales reps (not internal so current user wouldn't help). If I need to add a column to all the reports I have to do it multiple times, is there a fix for this? Thanks!
-
Putting a picture on a form
Is there a way to add a picture to a form? I am creating a form for suppliers to sign and there is a list of prohibited materials we do not accept. We have it as a jpeg with images of what we do not accept. I was looking for a way to get that put on the form they will be signing stating they are not giving us any of those…
-
Duplicates
I have a student sheet that I am copying over for the next semester. I copied only the data but didn't want the comments, attachments, filters, links, etc. However, there are duplicate names on sheet and I want to know if there is an easy way to find those rows and delete them. Any advice is greatly appreciated.
-
IF AND statement
I am attempting to build out a system which checks a box based on a hidden checkbox and a drop down field. If the hidden checkbox is checked, and the dropdown field shows either "In Progress" or "Not Started" the visible checkbox is checked. If the hidden checkbox is checked, and the dropdown field shows "Complete" the…
-
Can we unshare one person on multiple sheets or workspaces at once?
Is it possible to unshare multiple sheets at a time that a person is assigned to? we let someone go and need to unshare all the sheets associated with that person. if not possible can we make it possible in the future? thanks Scott
-
SmartSheet Alert Mail Sender
Hi all, I am the owner of 10 sheets each of one is used by different users. I have set up alerts automation but when the email is sent, it is always shown my email address instead of that of the user. This is a problem as the email is sent to external customers who are always receiving email from me and not from the…
