-
Calculating Age from DOB Column
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 born in the 1940s. See the screenshot for details. Any idea what I'm doing wrong? As always, thank you.
-
Index Match
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 under the same circumstances as the one above: Anabelle pruned is a Boolean, Annabelle Name is a text box. The error is…
-
Merged: Column Formulas Display Forms
This discussion has been merged.
-
Confused on Index Collect, Join
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 description in a separate sheet from the large master sheet containing the data). All is well here. At the bottom of the this second…
-
SUM IF / COLLECT / AND all are failing
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 perspective there are 300+ rows in the sheet and it grows daily. There are 8 possible priority settings, one is text. I have…
-
Formula to make a metrics sheet to build a pipleline dashboard
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: Account type, Weighted Forecast, and Expected Quarter Close. In real words, I want to say Weighted forescast is $1M for…
-
Is there a way to show a particular image in a dashboard depending on which option is selected?
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 location is open or closed through a Metric. I want it to look a bit better so have included a picture of the locations as in…
-
How to Structure Formulas so if dropdown options change, it auto-updates?
I am trying to compile metrics and get them to auto-update to reflect the values of a drop down. For instance, if the drop down has options like "Physical Exam", "Digital Exam", "Advanced", I'm building columns in my metrics sheet to tabulate the totals for each using countif statements (for each respective month). E.g.:…
-
Due Date based off a workday schedule - Need Workday Formula Help
Hello everyone. I'm trying to use a WORKDAY formula to auto-update a list of due dates. We have several financial tasks that must be completed a specific workday every month. For example, the books need to be opened -1 to the start of a new month. But this needs to be a workday. I have been trying to setup the formula so…
-
Trying to Join Multiple Rows to one cell
I am trying to combine all of the data into one cell for a row, but also any additional rows that share the same PO #. I then plan on taking this information and moving it to another sheet in order to set up Shipping and Delivery notices. I am still pretty new to smartsheet and I have tried googling and watching videos on…