-
Count Column A based on Column B
Hi. I have one column "N/R" which has a type of store opening New or Relocation. I then have another column with the date that the store is opening (this is a date column). I am looking for a formula that would count how many new stores or how many relocation stores are opening in the current month. I could probably writeโฆ
-
Smartsheet GPS Location
Hi, Iam looking for integrating Smartsheet with GPS location , i know that it can be filed from A form using the location button , but i need solution to collect the GPS location using something like the System Columns in Smartsheet (Created By - Modified By...ETC)
-
Sheet Update Display on Dashboard
Hi Smartsheet Community! I've reviewed and tried a couple different formulas for my question, but none have seemed to work. I am trying to display on a dashboard the last time a form was submitted and entered into a grid/sheet. I can manually enter the update into the dashboard, but I would like to automate it to pick upโฆ
-
How to count tasks occurring over a date range based on another column parameter selected
Trying to set up a formula to count tasks happening during a date range based on another cell drop down ie approved, not approved etc, any ideas? Thanks
-
How Do I Return a Negative Number
Hi, I need to return a negative number in a cell. The example is that a Change Order has been submitted, but not yet approved. Therefore, it should not be counted in the Actual Price column. If it is Denied, it would also return a negative number. Thank you.
-
Lookup To Return Multiple Results
Hi - I've done some research, but am struggling to find the best solution on this one. I am trying to do a lookup from one sheet to another based on a Unique ID. A VLOOKUP returns only one result, but I'd like to return all of them back to one cell in the other sheet. It seems like some combination of COLLECT, JOIN, etc.โฆ
-
RYG formula assistance
I have a formula in a RYG column that should change the color based on date and % complete. I think I am missing something. Only red or green will show, i have not successfully made it turn yellow. It will just be blank, red or green. =IF(OR([% Complete]@row = 1, [Start Date]@row > TODAY()), "Green", IF([End Date]@row <โฆ
-
Cannot add cell values generated by formula
I have tried to add cell values to each other, where they are created by a formula they just add to each other ie. column 1 cell 1= 1 column 2 cell 1 = 2 total = 12 (should be 3)!!!! what formula should I use? Thanks
-
Get a date from a week number
Hello everyone Do you know if it is possible to get a date from a week number information ? Here is the exemple : I have data structured in this format : 2020-13 (Year-Weeknumber) I would like to convert this data into a date, for exemple firstdayoftheweek/month/year. Do you know if I can set up a formula like this ? Thankโฆ
-
How do i track progress based on output?
I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadsheet, but would like to have it as part of my smartsheet plan. Am new to smartsheet!โฆ