Trending in Formulas and Functions
Combine Multiple VLookup Results into 1 cell
Hi, I am wanting to display multiple vlookup results from a separate sheet into 1 cell. Example: Cabling Allocation Sheet, where we input an allocation to a text name "ECC" which can be multiple cables in the same run. Requirements Sheet - Need the output to be "115, 116, 117" (I have manually written them in at the…
How can I accurately identify the day of the week in my survey calculations in Smartsheet?
I am reaching out to seek your assistance regarding an issue I'm encountering while calculating the number of surveys completed on each day of the week (Monday-Sunday). Despite various attempts to identify the correct day of the week using functions like DAY, WEEKDAY, and DATEONLY, I am consistently facing discrepancies…
Pesky COUNTIFS with OR formula
Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…