-
Conditional Cell linking between multiple sheets
I have created two sheets, one for budget tracking and one for tracking PO's and Invoices. I would like to link the two sheets conditionally when and invoice is marked paid. When an invoice is paid, the current date is marked as the paid date. I would like the Invoice dollar amount to be added to the budget sheet in theā¦
-
Webform Uploads
How do i create a webform with multiple file upload requests?
-
Web Form Feature Request
It would be helpful to have the ability to add a comment field to a webform and have the comment go directly to the comments for that row. Currently, we have a comment column, but the comments can be long and if you do a text wrap, it really creates a visual mess on the sheet and notifications. We also are required in manyā¦
-
Feature Request: JOIN() carriage return separator
I would like to JOIN() to allow the carriage return as a separator. This would allow me to transpose the data. JOIN([Column1]23:[Column12]23,"\n") would take the row and give me a cell with the contents transposed vertically. JOIN([Column1]1:[Column1]22," ") would take the column and give me a cell with the contentsā¦
-
IMPORT first CSV column as TEXT instead of NUMBER
I don't see a way to force my first CSV column to be treated as TEXT during an IMPORT, even when that column sometimes contains data that looks like a number. A simple example of this would be a list that has 2 digit hex values from 00 to FF. The lines with A-F get treated as text, but other lines are subjected to leadingā¦
-
Card View: 'View by' Default when Publishing
Hello, I am sharing a card view using the following: Read Only - Full Available to anyone with the link Default View - Card Left Toolbard Display - Hide Toolbar When I share I have the View By: Status selection on the sheet itself. When you Preview or go to the link the View By defaults to the first drop down column on theā¦
-
Make your mark on Smartsheet's next strategic feature: conditional notifications!
Check out our conditional notifications prototype and provide your feedback through a 10 minute usability test:Ā https://s2.userzoom.com/m/NCBDNjUwUzY2(Firefox, Chrome, or IE8+ only). Thanks for your participation! (Note about the testing platform: after you complete a task, click the "Success" or "Not Sure" button at theā¦
-
Date Validation
I am able to limit date entry to only current month and greater but I need to allow an entry of last month date upto seven days of the current month. UltimatelyĀ I want to limit the date entry into a cell to only allow a past months date seven days after the current month. I would like to use Validation for this.Ā
-
Downloading Submitted Forms as PDFs
Can I download a form as a PDF that has been submitted or do I just have to look at the row in smartsheet? It is a very long form, so looking at the responses in the row is not the most user-friendly method.
-
How do I add today's date based on another cells data?
I know I am missing something simpe, but I want to add "todays" date based on a drop down selection of another cell. =IF(JAN6 = "Paid", TODAY()) When I use this i get the error:Ā #INVALID COLUMN VALUE and if I add in the column and cell it gives me this: =IF(JAN6 = "Paid", JAN7 = TODAY()) #CIRCULAR REFERENCE Any ideas?