Using Smartsheet
Want to know more about using forms? Interested in better understanding automation? Want to see what's possible with dashboards? Post your question or discussion to Using Smartsheet.
Discussion List
-
New Forms Enhancements - Symbol images and unrestricted dropdownIn Using SmartsheetHi Community, I’m pleased to tell you about two enhancements we just released for web forms and the form builder. First, it is now possible for web form respondents to select list values and/or enter their own values in the same contact …
-
Formula to Check Duplicates on a Multi-Select Drop DownIn Using SmartsheetTo evaluate each value within a multi-value cell is what has me stumped. 'CountIf' exceeding 1 is the key for single values. I thought about using 'contains'. I'm curious if anyone has figured this out.
-
Restrict date field to only specific day of the weekIn Using SmartsheetI have a date field in my smartsheet that I need users to select a specific date, but I would like to restrict them to only be able to select Fridays. Is there any way to do that on the form? I do not want to have to prepopulate a drop…
-
Roll up not working as expectedIn Using SmartsheetI have a project with several tasks that are children of a parent task. The roll-up of the Work and Duration fields of the parent item are not working as expected. For some parent tasks, the roll-up seems fine, but I have other parents who…
-
Inbound cell link loses timestamp info and only shows dateIn Using SmartsheetHello! I am trying to capture times clocked in and out by a team. I created 2 input sheets, one that captures time in via a system timestamp of last modified, and another to capture the timestamp for when one clocks out. I am then pulli…
-
Image in a WebformIn Using SmartsheetHi, Is there a way to feature an image in a webform? We are looking to have people select which image they prefer. Thanks Community!
-
how to make decimals work?In Using SmartsheetHi i´m having a #UNPEARSABLE error everytime y tried to use decimals in my formula, for example: =IF([KPI ASIGNACIÓN DE OBRA]4 > 3; ([KPI ASIGNACIÓN DE OBRA]4 - 3) * 0.01) how can i multply with decimals? Thanks
-
Copy and paste a row of information from smartsheets to an emailIn Using Smartsheetis there a way to copy a row of information and paste it in an email to send to someone rather than having to retype the information in the email? Smartsheet doesn't seem to want to play along lol. for instance Example I cant copy and …
-
How can I send a reoccurring email with an embedded link to a survey form?In Using SmartsheetHello All, We currently have a survey form that we send twice a week to our team of 20 plus employees. We also have a helper sheet that uses formulas to gather this information into the statistics we want to share. We currently do this…
-
Basic automation not working right?In Using SmartsheetI thought I set up a very simple automation but it doesn't work even after trying variations. I just want to send an alert when an entry in one cell changes. I set up a column using Yes and No options (default is blank) so that when some…
-
Report access without base sheet level accessIn Using SmartsheetHi, I have a user that needs access to a report (which filters the data based on a parameter and only returns certain rows). However it doesn't seem like they can view it unless: I make the report public, which isn't an option as it conta…
