How do you create a report that counts the number of each status on a sheet? I want to create something similar to this template but with my actual statuses not these preset ones. How can I either cha…
Does anyone know if Smartsheet has a threshold limit on the number of VLookups that can be used within one sheet? I have 7 columns with a max of 300 rows of data in a Target sheet, I am wanting to run…
I am a little confused and unsure if I am configuring this feature correctly. I have a Smartsheet with a Contact, Status, and Entry Date columns. My goal is to have a reminder automatically sent, begi…
When we set reminders/alerts it goes out as an email. Is there another option for the reminder to appear a a pop up as in outlook? Also, if we have a contact column and a date column, is it possible f…
Does anyone know if files will continuously sync from Dropbox? I've followed the directions to attach files to a workspace from Dropbox, but any changes I've made to those files IN Dropbox are not syn…
Hello! I am trying to reference another sheet that has multiple data for the same building: On another sheet I am trying to pass over the information from Column4 if Column3 equals "Cobb Stadium" and …
Hi All I need help in using the contents of a Dropdown Multi Select Column. The column has the following options A B C I want to use the actual content say AB to lookup another Smartsheet for a price …
I understand that if I create a workflow to move rows with cross sheet references into a new sheet, that the cells with my formulas will not maintain the reference. Is there a way to move those rows a…
Trying to add up the number of people from all cities but, CityA, CityD, CityF, etc in the same argument. Is there a simple SUMIF formula i could use? Currently I have been using: =SUMIF([City]1:[City…
Hello, Hoping to get some help for a rather complex nested if formula I'd like to build based on responses to a webform. Below are the conditions. Is this possible to create an if formula around these…