-
IF(ISDATES and Blanks)
=IF(ISDATE([A]@row), IF([A]@row < TODAY(), "Expired", "Valid"), IF(ISDATE([B]@row), IF([B]@row < TODAY(), "Expired", "Valid"), IF(ISDATE([C]@row, "Valid", IF(ISDATE([D]@row, IF([D]@row < TODAY(), "LATE", "Out for Quote"))))))) I have the following statement above. I'm trying to have it say "Late" if Column C has no date…
-
Automate Fillable PDF
Hello, I have created an "inquiry form" in which employees submit general information regarding a request. In this form, employees select from a list of request types, one request type in particular we would like a follow-up form automatically sent to the requester. The idea is they would receive/complete the follow up…
-
Document Builder - Mailing Address
Hi! I need to be able to pull data from multiple columns to make a single mailing address field in Document Builder. Example: Column 1 = Client Name Column 2 = Client Street Address Column 3 = City Column 4 = State Column 5 = Zip And I need it to look like a real mailing address Client Name Client Street Address City,…
-
Automated email not working
Hello! I'm know that this is going to end up being something easy but I can't see to make this work. I have a sheet that tallies ratings and gives a % of that rating towards the target. The column is setup as a text/number and has the number as a %. Once a week, I'd like an email to go out that lists any of the different…
-
Template for booking shared office space
Hi, I was hoping someone could offer guidance on a template for booking shared office space. I'm sure it exists. If anyone has a form they can share that would be extremely helpful. Thank you in advance.
-
Tracked changes in Word Documents Attachments
Hi, We are trying to upload word documents to a row, which includes track changes. While the tracked changes are visible in the original document, they are not once it is attached to the row. Has anyone experienced that? Is there a solution to this? Ute
-
Auto-populating A Form Field
Hello, I currently have a form that asks users to select a product from a dropdown list. Is it possible to auto-populate the email address field so when a product is selected, the email address associated with that product automatically pops-up?
-
Proof Tracking
Hello! I am pretty new to smartsheet. We are trying to use the proof function to gather approvals on our projects. We have several different projects working at the the same time. Is there a way to create a report to see which proofs have been sent and which have been approved?
-
Locking report settings
Is there any way to lock a report's settings once it has been set up ? I can't find anything in Smartsheet about report settings and have some concerns inexperienced people may go in and accidentally change things.
-
INDEX/MATCH on Blank and No Matches
Hi all, Working on using Index/Match to pull through a Single Select Dropdown (Y or N) if the corresponding PO exists. As standard, I'm using IFERROR to populate to ensure if there are errors it shows a more user friendly message. =IFERROR(INDEX({QC sheet Range 1}, MATCH([Product PO#]@row, {QC sheet PO Number}, 0), "Task…