Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Sum cells in a column based on check box status?
I am currently using a SUMIF formula (which works as expected) to sum values in a column when a row contains specific text =SUMIF($[Activity]$29:$[Activity]$344, "Consultations", [FY 2016 YTD]29:[FY 2016 YTD]344) Now I want to add a check box column so I can an another clause to my SUMIF statement to sum only those rows I…
Field Labels in Card View
Hi - I'm experimenting with Card View and am wondering if there is a way to include the field name as a label on the Card. I have multiple numeric fields that I'd like to display on the card - number of teams affected, # of hours estimated, site priority. I know their positions on the card but others will not. Let me know…
Check box - how to auto record user details once selected
Hi Guys, I am using a checkbox to indicate when a particular task has been completed, but i need it to automatically record the user who changed it and when this occured. Can anyone help me with this, or suggest another way to make this work. Thanks in advance, Brett
AppSheet - Data search and data displayed
I would like to create an App using AppSheet that has the capability to search my smartsheet data and return / display specific data. This feature is available now but the first page shows all data - I would like it to be blank apart from the blank form field anf search icon. For example if I searched for HASU4405127 it…
Line links between different sheet
Hi everybody, wouldn´t it be nice to link not only cells but complete lines between different sheets. Off course it is a question of matching collum names. But a simple possibility would be to match the cells by column name. Not matching columns, cells with system values or cells with formulars could be ignored. A little…
Uploading a List for Dropdown Values
Can you upload a list, maybe .xls, of chooses into the Dropdowns Vaues for the Dropdown List? I want to load a few hudderd Rooms so when using the mobile app one can just choos the specfic Room they need when entering data in other fields for that room.
Forward Email
Is there a way I can forward an email to Smartsheet and start a new line item? Even better, is there a way to integrate an email back/forth into updating into the comments of a SS line item? Trying to find a way to keep track of emails via SS. Maybe there is an upcomming integration with Front App or someother email…
new cards position top/bottom
Is it possible to make new lines appear at the TOP of the lane in cardview?
Calculate Total Time Spent Filling out a Webform.
Thank you all in advance! i was hoping to capture 2 time stamps from a webform automatically. Idealy the webform would capture the time the user started filling in the first field on the webform and then capture the time the webform was completed/submitted. Idealy, the solution should not involve the user entering a time…
Website form integration using API
I am attempting to use the API to add comments into a new row created by a form submission. I am currently adding new rows to sheets through forms on our website that integrate with (amung other things) the Smartsheet API. Our website utilizes C# so I am using the following code (partial) to submit to a sheet. Cell[]…
