-
Is it possible for a sheet owner to view outgoing form confirmation emails?
If not, is there another way to generate a document summarizing the incoming form?
-
Web content widgets in dashboards and PDF files
Does Smartsheet not support embedding PDF files into dashboards? Looks like Adobe XD CC is supported but I'm not familiar with that tool. Does anyone know how to get a PDF containing hyperlinks uploaded/embedded into a Smartsheet dashboard? I'd also like to retain the hyperlinks in the PDF so that viewers can still…
-
Import related data into Master registration sheet?
Hi all! I am making a registration form for students who will be attending a summer camp. Because they are minors, we need agreements (I am structuring these in a simple "check the box if you agree to the code of conduct" format ) from both students and parents. The catch is that students and parents may not be filling the…
-
When to use @ROW
Is it best to use @ROW whenever possible over the actual row number? Can @ROW only be used in simple formulas like =[Column1]@ROW? Or can it also be used in more complex formulas like =[Colmn1]@ROW+[Colmn2]@ROW+[Colmn3]@ROW
-
Is it possible to set up conditional formatting to alert when a duplicate entry is inputted?
Is it possible to set up conditional formatting to highlight or alert someone if a duplicate entry is being inputted? I am looking to highlight the DOC ID if it has previously been entered into the sheet.
-
Does smartsheet form allow skip branching?
Curious - we are starting a survey campaign with all of our current and future clients. I am looking to see if I can use smartsheet, OR if I will need to use survey monkey or SOGO. I already use and love smartsheet for just about everything, hoping to continue that trend. Will smartsheet forms allow skip branching…
-
Countifs + Contains or Find Formula Help
I require assistance please to create a formula based on two criteria: COUNT "SPI Quoted Value" column, when >0 and when "Date" column CONTAINS or FIND "January" Therefore if I only selected the first six rows as example, the SPI Quantity cell would return the value of 4. I tried this formula, however didn't work…
-
How do I include Contact List Columns in Concatenation?
I need to create a primary key on a page that includes 3 text columns and 1 contact list. The formula errors when I try to include the contact list, but works fine without it. Is there a way to reference a contact column as text or get it to just read the name in the contact for that cell as text?
-
Using IF Statement & DATE
I'm trying to combine formulas that if a check box is clicked, it returns the number 7 to me or else it runs a formula for subtracting dates from TODAY but unfortunately I keep getting #INVALID DATA TYPE =IF(OR(COMPLETE@row, "7"), (TODAY() - DATE@row)) Any help would be great appreciated. Thanks.
-
Trigger reminder on absence of comments
Hi, It looks like the "modified" column doesn't update when a comment is added to a row. Comparing this date/time value to today's date/time value is the only way I see to automate a reminder when a row has not been updated (and by updated, I mean a comment left on the row, not a cell changing). example - remind 'assignee'…