-
Formula adjustment for a Monthly sum versus yearly?
Hello, I am trying to implement a look back to December 2024 figures - formula below totals 2024 entire year. I know I'm overlooking where to insert the month, nothing seems to be working as I play around with this. Any suggestions? I've got to be missing something very simple. Exiting Formula for total 2024 data:…
-
Filling a Contact List from another sheet
Hello everyone, I have a sheet that has a list of all of the managers and supervisors in my organization and I keep it updated monthly. I have another sheet that has a Contact List field and I am trying to see if there is a way to connect the Contact List field to the Sup/Mgr sheet, so that it automatically updates when I…
-
Change Background Color of Dropdown Bubbles
Is there a way to change the background color of the dropdown bubbles? On the main report, everything is in its own gray dropdown bubble, which is best for black text. However, when I run a report, the dropdown bubble is removed, leaving the text over a background color that varies with our color coding. In this case,…
-
Form/Sheet Question
I've created a form with a dropdown menu list. Once I fill the form out and submit it, all of the multiple options I've selected appear on one line in the sheet. Is there a way to get each option selected in the dropbox menu to then be on its own separate line when populated into the sheet? We have several different…
-
App Issue
Hello, I am using a Smartsheet App on Samsung Tablet. When the Contact List Column is Restrict to list values only is off, users cannot type in this column. I can also have the column be set to a drop down, but I would rather have it be the contact list where they can add manually their name. thanks
-
SUM Collect for Multi-selection Dropdown Criteria
Hi, I am looking to sum the total Services Revenue for all Opportunities with a Technology that includes "Custom." The Technology column dropdown is multi-select, so users can call out multiple technologies in addition to Custom as shown in the example. Other criteria such as Sales Stage will be included in the summation.…
-
Row automation - add to top of sheet
Add an option when using automation to move/copy a row to add the row to the top of the sheet.
-
Smartsheet automation
Hi Everyone, I am trying to figure out a way to automate a sheet that I have to send the submitter a response when a comment is put in the row with their question or request. I tried adding a column that has a yes or no- response required. I was trying to set it up so that if they checked yes, then they would receive a…
-
Copying a one cell to another between sheets
I am trying to copy a specific cell from my main sheet to another cell on a different sheet. I have tried using the cell linking feature where I right click the cell I want the information to go and select "link from cell in another sheet" then select the cell I want on the main sheet and select create link. When I do this…
-
Fields to be allowed to be side by side
Hello, I'm creating a form to capture new data for employee changes, on the form it would be great to be able to have fields side by side so end user can compare. Is that something that could be possible in the near future?
