-
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!…
-
Date changes to tomorrow after 5pm
Hello, I have been trying to find a work around for an issue I am having on sheet we use. We are currently using a sheet for employees to submit when they check out and check in equipment via a form. We were using the auto created date column to run reports on what equipment were checked out vs. available. We discovered…
-
Best way to manage an iterative process in Smartsheet
We are planning to implement a book publishing project in Smartsheet. At one point in this project, the pages of the book go back and forth between the writer, editor and compositor till it gets finally approved with no further changes being required. The number of times this cycle repeats itself is unknown, however there…