-
Is there a way to automatically copy filtered content from sheet A to sheet B daily?
I have a sheet (sheet A) that is my source sheet, and the content is updated frequently. I'd like to filter sheet A on a particular column, and copy the filtered content to another sheet (sheet B) to share with my users, automatically at a daily basis. Before copy, content in sheet B needs to be cleared. I tried to use the…
-
Fill across not working as expected?
Wondering if anybody else is experiencing this - I have performed this scenario hundreds of times without issue so wondering what's up! I have a formula based on full Column:Column ranges. The criteria ranges are set with $, the range to sum is not. When I click the + symbol at the bottom right of the cell and drag it to…
-
Netdays Negative Return
Hi All! I'm running into a quirk when using the netdays formula."Create Date" is a system generated column used for the start date, and "Resolution Date" is the end date. When I have a record where the resolution date is the same as the startdate, I'm getting a -2 for the netdays between these values. Any idea what's going…
-
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…
