-
How to indicate that a cell will be automatically calculated?
Ultimately, I want to indicate to users when a cell will be automatically calculated, so they don't overwrite the formula. I've figured it out in one case, but not in another. Both are shown below. So, more specifically, any ideas on how to detect a blank cell when using =MAX(DESCENDANTS()) in a Date column? I have a…
-
Match Volunteers to Meetings
I need a way to match a list of volunteers to meetings in their area. Sheet A houses volunteer information, and the input is a Smartsheet form. Very basic, houses employee info and state (has multiple name columns because I added the "Name" column as a contact column while I was playing with formulas. Ultimately, it will…
-
Different View of Report, depending on the location, from where the report is accessed.
I have a report called "My Tasks" in my workspace, I also have a shortcut to this report in my Dashboard. When I click the report from the Dashboard shortcut, the view is different from when clicked through the workspace itself. Different columns are seen in the two views, although I have set it to show only one. It even…
-
Formula-Reference another sheet and see the column rather than(SheetName Range #)within the formula
Hello, I have a formula I am using on one sheet. The sheet is named "Mark" since he is the Point Person. =COUNTIFS([First Contact Year]:[First Contact Year], "2020", [First Contact Month]:[First Contact Month], "Jan", [Point Person]:[Point Person], "Mark") I have another sheet named "Summary - 2020". I want this exact…
-
Avg(collect) across multiple columns, for specific criteria = unparseable
Hi I am trying to get an overall average % complete for all locations for their "Adoption" phase. While trying to debug it, I got an average of everything to work for my "Average Score" summary field. I used this formula: =AVG(COLLECT([NA Hub]1:[Haarlem MSDIS]140, [NA Hub]1:[Haarlem MSDIS]140, ISNUMBER(@cell))) Next, I am…
-
SUMIF with CHILDREN
Working on a formula within a sheet where I am trying to sum estimate amounts based on their % closed. I have 2 categories we have created using children/parent (indenting) I want to only count the projects that are within 1 category. My formula is =SUMIF(CHILDREN({A LEADS}), ({% CLOSE}=25%), CHILDREN({Amount}) This keeps…
-
What Formula Would Handle This?
I want the top row to calculate everything below it. I was using the Sum Children formula, but once I made the indent below with "Flavored Kre Pre-Launch", it won't calculate anything below it (just only if I put something in that same row). So, is there a way to write the formula in the top cell to read all of the ones…
-
Report row limitation
Hi all, I have noticed that there is a row limitation in the reports that i am generating. I have read that there is not such a thing, but it is happening with my reports. It seems that is limited to 392 rows only. Can you please help? I need to submit my reports ASAP. Thank you, Aspasia
-
Update cells via form or secondary sheet?
I have a sheet of contracts with 30 columns (status/progression/etc). The columns are updated by different people in different departments. Is there anyway to create a form that would have a dropdown of the contract ID and then the cells I need updated? If that isn't possible... Is there a way to make an automatically…
-
VLOOKUP equivalent -- #NO MATCH error
Hello! I have a formula I'm using across several sheets referring to a source table. On 9/10 sheets, the formula works just fine. However, on one the exact same formula yields a #NO MATCH error. I've double-checked my references and everything looks good -- e.g., the match criteria does indeed exist where it should. Any…