In process of creating a formula and I can't seem to get it to work correctly. Any feedback is welcome. I have two columns. Both are drop downs. Column Program: A, B, C Column Status: A, B, C, D, E Wo…
I have no idea how the program thinks that the number 2 even approximately resembles the word "Sparks Corp". I want to use fuzzy math to find the closest vendor name to the one that is typed in, and w…
Hi Everyone, I got a great formula from Customer Success that I thought I would share. I wanted a way to know if a project was at least 1 week or more behind schedule. This is what Customer Success ga…
I'm needing help completing a formula. The formula that is needed will look specific data in column "A" then specific data in column "B" with the result of these to coming from a different little grid…
I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever th…
All, Have a smartsheet that shows by student (each row is a student) what course they are required to take. The student updates the date they completed the course via update requests. Based on this sm…
I'm having an issue understanding COUNTIFS in my scenario. I'm trying to track billable hours, and I'd like to summarize the hours value listed if another column equals a specific value. So I can trac…
We do a customer follow up for every job we do. We ask 3 questions rated 1-10. If "Overall Score" column totals 26-30 points - green ball 20-25 points - yellow ball >20 points red ball. I can get the …
Hello, was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automaticall…
