-
Index/Match Function help for Indexing multiple Columns
I'm creating essentially a search engine for my organization to quickly pull data from a large data collection. I am running into a wall with the Index/Max function and trying to get Smartsheet to be searching multiple columns to pull the information from a column in the row with the #1 in the row. Staff will submit a form…
-
Nominate Peak Humans & get a badge!
Hi Smartsheet Community, We loved learning about what operating at your peak looks like for you, and now, we want to give you the opportunity to recognize and celebrate others, and earn cool badges as you do it 😉 The Operate at Peak Human campaign is a celebration of humanity. Recognize someone who does a great job in any…
-
How do I trouble shoot wrong date/time in a created date column?
I have a sheet that records tenant inquiries. I do not have a date field in the form, I use 'created date' in the worksheet. It's been working fine, except for yesterday. I received two tenant inquiries with days in November and weird times. I'm not even sure how to trouble shoot this. I went into my date and time settings…
-
Develop a ranged function that stops at the row above
I am trying to develop a function that will collect the maximum value in the same column for all rows above the current row. My initial formula was =MAX(COLLECT([Sim Exp Yr]$1:[Sim Exp Yr]1, $[Email Address]$1:$[Email Address]1, $[Email Address]@row, $Certification$1:$Certification1, CONTAINS("SimLab", @cell))) Which runs…
-
Formula help please! What formula to mark the parent row "Complete" with an "Not Applicable" task?
In my status column I am using this formula auto update my my parent row: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(), "Not Started") > 0, "In…
-
Need formula to remove characters from a column when added
We export data from another data source and cut and paste it in the Smartsheets Column AOY Status. The issue is after we cut and paste the data there are going to be certain characters I need removed. For example: The data we cut and paste in will have Down <20 days or Down >20 days. When we cut and paste that data I would…
-
Formula to calculate the difference between two numbers based on a month in another column
I am unsure if it is possible to do what I want, but I wanted to ask. I have attached a copy of my grid. I want a formula to calculate the difference between the largest and smallest numbers for each well for each month. For example, for well #2 in month one, find the largest number (58650300) and subtract the smallest…
-
Get the DisplayValue of a Hyperlink
I have a column of currency values that are hyperlinks to receipts. I want to total the column but the SUM function does not recognize the displayvalue (the currency amount). How do I Get the DisplayValue of a Hyperlink? Thank you in advance
-
Field Type: Related Sheet
There should be a way to link data from Sheet A to Sheet B. For Example, we have a sheet A to track all of our vendor demographics. We then have sheet B for tracking invoices. On that sheet we have a column for Vendor. We have to maintain our Vendor Sheet and then update the Vendor column on the AP sheet so the drop down…
-
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,…
