-
Conditional Logic in Forms
I’ve started building a form in Smartsheet using the Smartsheet Form Builder, and the responses are successfully populating my sheet. The challenge I’m running into is creating conditional logic within the form to narrow down selections. For example, if a user selects a state (such as Florida), I’d like the next question…
-
How do I get the exact number of Years based on the date column (no more rounding up)?
Hi there! Can anyone kindly please help me with this - I'm new to SmartSheets and having trouble working out formulas… In one column I have dates that Volunteers started volunteering with our company. The second column I used the following formula to get the number of years that it totals: =YEAR(TODAY()) - YEAR([Vol Start…
-
Interactive Graphics
Here is my goal: I need to create an image where the image has multiple areas. If one clicks on the that are (much like an image map in HTML). Then I need a secondary window to open where the use would select the status on that area. In Progress, not Started, Complete. But also I need it to show the last note added to that…
-
How to return a blank when searching for max date and one of the dates is blank
I'm searching another sheet date column for the max date where two number columns (CID) are equal. It works fine, but if the list of dates contains a blank, I want the formula to return a blank instead of the max date it finds. =MAX(COLLECT({DAFD}, {CID}, @cell = [CID]@row))
-
Character limit for pull-down menu items
Is there a limit to the number of characters for a pull-down menu item? If so, what is that character limit and are there any other limitations such as special character use?
-
Sorting Dropdown Columns
I feel like at some point, sorting a dropdown column ignored the column properties. This was nice because I could add and remove options as needed, but when I sorted my rows based on this column, they would sort properly. Now when sorting a dropdown column, it is based on the column properties. Now we have to manually sort…
-
Web Version Loads The Same Sheet
Hello, With the new update I'm experiencing an issue I didn't have before. I use Smartsheet web version because I typically work with 20-30 tabs open and it makes it easier to use than the app. Since this new update, every day when I open my laptop I am prompted to log in (as usual), but when the sheets load they all open…
-
SumIF formula help
I am trying to find the right formula to use in the scenario if a cell in the row is yes, then it sums cells in the same row to create a total. threshold totalscore1 totalscore2 totalscore3 Final score yes 46 10 9 this would pull a total for the 3 total score cells in the row no 15 75 12 this cell would not total because…
-
Merged: We need a way on a Project Schedule to delineate certain items can be completed on the weekend without turning it on for the whole sheet
This discussion has been merged.
-
Enable attachments in automations when using 'message only' option
We receive data from externals which we then need to verify. Once it's verified we then email them back a PDF (that's been generated using 'generate document' feature) as it contains the crucial information that's been verified, and they can keep as a confirmation. Currently, I use the message only format in an alert…