Hi All I am trying to create a smartsheet formula for the Summary field that will return the maximum someone in a Senior Quantity Surveyor role is being paid currently in the company, plus the name of…
Hi! I have a sheet where one column has a submission/end date ("END DATE: CA Exam 4 Part 2") and another column is a "due by" date ("E4 Window Closes"). I have a column that I keep hidden which has th…
Date formulas are the most challenging for me. The requirement is to provide a visual calendar that will trigger the quality audit team to complete the audits expected for the current business day. Th…
Group, I’m calculating people's age on their birthday this year using this formula: =YEAR(TODAY()) - YEAR(DOB@row) It works for most cases, but for some reason, it returns a negative number for people…
Hello All, =IFERROR((INDEX((COLLECT({Annabelle Pruned}, {Client Name (Pruning)}, [Client Name]@row, {Annabelle Name}, "Annabelle"),1),0) This formula I've used (with the help of the pro desk) elswhere…
i have a sheet with a column with the number of records matching a code number (CodeFM) from another sheet. I have summarized the number of records for each code number (along with the code descriptio…
I have tried several different ways to do what I thought should be a simple calculation. The purpose is to add Hours from one column where the Priority in a second column is either 1, 2, or 3. For per…
I have a sales tracker sheet and need to continuously pull data as new quotes are formed to show wins/ losses compared to our target in a dashboard. Sheet has 3 columns that need to create the formula…
Hi Everyone, I am creating a dashboard that will show which locations are open so the senior managers can quickly check in the morning. It is simple enough and will show on the Dashboard that the loca…
