-
In Smartsheet why will the overall % not populate when the column is highlighted?
In Smartsheet for my percentage column it is only showing me a count when highlighted not the % avg. When I am trying to pull this data to other reports the formulas come back # Divide By Zero but the data is there. Please see screenshots below first image is the original data that does not show the overall avg when…
-
I need a formula to create a Contract iD for 4 different org's that are listed in 1 column
I need to create a formula in a column that will in the end give me something like ATF021 or RDI231 or RD473 Each org, ATF, RDI and RD will have their own contract iD; so ATF021's next line item needs to be ATF022, 023. Then if the RDI org enters a line item, there contract iD will be RDI231, RDI232, RDI233 and so on. Same…
-
Using DISTINCT function
I am trying to use the distinct function. It seems like it should be relatively simple, but I am getting an error message. Am I doing something wrong? Thanks
-
Index/Match with Has and Specific Select
I have an master roster and each week I need to ensure a response for each. Since each responder has mutliple areas of responsibility, one submission may cover multiple items from the master roster. I used an index/match formula however when there are multiple entries in a single line, I get a #No Match. And now that the…
-
Counting Item that meets Criteria.
Good Evening Community. Trying to count an item that meets certain criteria. For example I am referencing two columns of the same sheet and trying to count the first column that contains Food POS and has a Projected Status of Projected Install. Below is code that has been attempted. =COUNTIF(AND(({POS Install Status},…
-
Formula Needed to Check Time From Created Date and Put Into 2 Statuses
Hi All, Trying to work with Created Date column to extract the time from Time Stamp, then look at the time to determine if it falls within two statuses. This is for a Rush Payment Cutoff Time. If an entry is submitted in our sheet before 1pm that day, I want the column to say "Same Day" and if after 1pm, have it say "Next…
-
Index/Collect while meeting specific criteria and doing math
Good afternoon community, I'm in need of help with a formula that I feel has come close, but still just off of the mark. I have three sheets: The first is holding static data (Inventory Cost sheet). The second sheet (Tool Inventory) is where data comes into the sheet from a form and some math formulas do calculations based…
-
Automatically adding new row data to formula
I have a few formulas on the top 3 rows of my sheet that are KPIs for the sheet. Since they consume the top few rows, I cannot select the entire column in the formula or it returns an error of Circular or Blocked. So I need to start the range with (ColumnHeading4:ColumnHeading99) and I cannot figure out how to always…
-
Perpetual Contract Renewal Formula
Hello All! I am trying to create a formula that will automatically update the end date to a contract based on a renewal timeframe. For example, Contract Start date 12.31.19, Contract end date 12.31.20 at the end of the contract, the contract will renew for 1 year perpetually on the same date. Right now we are at 11.8.24,…
-
RAID Risk Matrix
Hi, I have the below matrix, is there any easy way to get the formula to do the various risk levels (low, medium, high and extreme)? I have attempted to try with AI the formula but for some reason starting with the last scenario of Extreme it stopped generating a formula.
