Formulas
Discussion List
- Hello, I have been using a symbol column to monitor updates for a master sheet of all of my departments projects: =IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODA…
- Hi community. I am working with @Laura Polson to help our field staff be able to track their schedules while out visiting stores for various reasons. We would like to find a way to show visibility bas…
- Hi Everyone, We have a critical issues list that is maintained by another group, and I've created an end-to-end schedule that will determine whether or not we will have the issues "validated" by our W…
- Working on a project that will have 100 or so sheets with exact same structure. I need an efficient way to be able to calculate data SUM, COUNTS, AVG across 100 sheets in one metric sheet. What is the…
- I have 2 sheets. We'll call Sheet A "Roster" and Sheet B "Grading Sheet" Sheet A has columns for "Employee Number" and "Email Address" What I am trying to do is on Sheet B, have a column in which you …
- Hi Everyone! I am a new Smartsheet user and am having some issues creating formulas that are based off of multiple columns where those columns are set up as drop downs with multiple selections. My For…
- Looking for help on writing a formula to be located in the Parent Row under the Forecast column Row 1 to sum children rows of all Salesperson except Mike. I manually entered a formula =Value2 + Value3…
- I'm looking for a formula that would be able to count the number of unique contacts that are in a contact column that match a specific date. I have a multi-select contact column that has the names of …
- Hello. I am trying to assign pricing according to requested testing, where each test has a specific fee associated with it. This fee is redacted in the below screenshot, but is formated as 123.45. I a…
- Hello, can someone help me with the left function within the index/match? This is what I tried but it always returns NO MATCH: =INDEX({Master Job SO}, MATCH(LEFT([Job Number]@row,5), {Master Job #}, 0…
