-
Date Range Formula
Hi, I'm trying to set up a formula to count the number of requests that were submitted between a specific date range. Below is the formula that I've written, however I'm still receiving an invalid operation error. Can anyone help me with this? =COUNTIFS({Citi Table Change Tracker Date Submitted} >= DATE(2019, 1, 1), {Citi…
-
if then... do this query.
In the below - column Principal Check I have put: =if([Principal survey drawing required?]2="Yes",[Principal drawing validated?]="Awaiting response","Not Required") I am wanting the Principal drawing validated? column to have an entry, "Awaiting response" based on Yes in column 'Principal survey drawing required?' column.…
-
Cross Reference Count Formula with Multiple Criteria
Smartsheet Community: I am trying to Count If the Checkbox is Checked, the Date is Less than August 5 or Blank. I know I am close but can not see finish the Formula Correctly. Current Formula Below: =COUNTIFS({Issue / Defect UAT LOG Range 3}, "1", {Issue / Defect UAT LOG Range 4}, <DATE(2020, 8, 5), {Issue / Defect UAT LOG…
-
track % complete based time elapsed
I have been working on this for hours and can’t seem to figure it out and can’t find proper support on line. This one is a time sensitive metric I am trying to get on our dashboard for our stakeholders to see. Any help you can give me would be great I want to track % complete based time elapsed in a current schedule based…
-
Can VLOOKUP match on the most recent row of duplicate entries?
I know my question itself is confusing, so let me explain. I have configured data to come into Smartsheet from SharePoint via Power Automate. It is depositing some basic metadata into a "From SharePoint" sheet (image included here). I am then doing a VLOOKUP against this sheet to populate some of that metadata on a master…
-
Percentage Complete based on Status
Hello! I have a list of 38 objects (planes, trains, automobiles, what have you...) and I want to find out what the percentage complete is for either based on status. Is there a way for me to gather a total % complete based on status? For example if 10 planes are set as either a status of Active - Stationary, Active -…
-
Checkbox to equal 100% in % complete
I am attempting to do the following. If the "Completed" column has a check, in the checkbox, I would like the % Complete column to read 100% Here is the formula I thought would work using task 4.of the project. =IF(Completed4 = "Complete", "100%")
-
Best way to auto Sum cells with both numbers and text?
Hi everyone - So i am trying to find a way to sum values in cells containing both number and text like "1 Macbook Pro, 2 Lenovo Tiny PC, etc. and give me the total for each item type in the totals column. Please see the screenshot of my example smartsheet. All of the column values are drop-down list of things we usually…
-
Can you help with a counting formula question?
Hi - I'm trying to create a count if formula that will include Bid Stage from one column and either of Open or On Pause criteria from another column. This is what I tried =COUNTIFS({2020.3.31 Antitrust MA Subgroup Chart Range 2},"Bid Stage", [{2020.3.31 Antitrust MA Subgroup Chart Range 1}, "Open", {2020.3.31 Antitrust MA…
-
Conditional Sum Formula
Hello, I am trying to insert a formula for extended price of projects that auto calculates for close rating of A, B and C. Any help is much appreciated.