-
Counting party size from Symbols
I would like to use the party size symbol in a form for registration, but am not seeing a formula that would count the responses?
-
Report view without access to underlying sheet
We are attempting to create a report view that is a subset of rows driven by a column flag. We have found that the report viewer will also have access to the underlying sheet with all of the details. Our goal it to provide a highlevel summary via the report and restrict access to the subtask details.
-
Inventory Sheet, moving data to/from Excel and SmartSheet
Hello all, While I have a lot of experience with Excel, I am new to Smartsheet. I've been given a project and I'm having difficulty finding a way to perform what I need in Smartsheet, and am looking for advice/help. Effectively, I have a master inventory list that is kept in Smartsheet of equipment we are configuring and…
-
Alerts for deadlines- Need help
Hi! I am trying to set up an alert for deadlines, but only if a box is checked- not for the whole sheet. So people can basically choose- yes, I want alerts for my deadlines, or - no, I don't want alerts for my deadlines. Right now I have a check box column set up- yes and no. So, I want it so that If the person checks the…
-
Smarter Dropdown List Manager
Further to a considerable amount of Community requests for a way to Update Dropdown Lists in just one sheet, then have that list Automagically populate all the other Smartsheets that reference that list. Our Developers, using the Smartsheet API have created just that solution, in fact we have assumed that users will want…
-
Formula Help- Check Box if Date is tomorrow
Hi! I need a formula so that if a date column is the next day, a box is checked. This is what I've started, but I can't figure out how to say- if the date is tomorrow... =IF(date:date=????,(1)) Any ideas? Thanks! Amy
-
Frustrating split of functions vs cost of license types
One very interesting thing for me is the curiosity I get from people around me when they see me using Smartsheet. The low threshold of knowledge to get into it and the "mimic" of spreadsheet (excel) view behind it makes it so much more attractive than MS Project for example. Often when I bring up MS Project as a possible…
-
Help needed counting across sheets
Hi all, I am trying to use the count of a symbol across some sheets. I know I can get this information by creating a report but for a more visual presentation, I am looking to get an actual number. I am currently trying something like this but it's not working: =COUNTIFS({sheet 1 Range 1}, 1, {Sheet 2 Range 2}, 1) The…
-
INDEX/MATCH not working
Below are two screenshots. The first is a screenshot of my target sheet. The other is a screenshot of my reference sheet. On the reference sheet I have a list along the left. In the column to the right is: =TODAY() On the target sheet is an identical list with the following formula to the right: =IF(TODAY() = INDEX({New…
-
return list from another sheet
Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item 1.. 2... 3.. and 7. I want to return the information relative to that ID for those entries. Thanks in advance!…
