Best Of
Re: Can you transfer a formula when youcopy summary sheet from one worksheet to another?
Hi @Idaly
I hope you're well and safe!
To add to Brett's excellent advice/answer.
If you copy the Sheet Summary to other sheets, it will include the values and formulas. (two options)
Is that what you need?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Re: Can you transfer a formula when youcopy summary sheet from one worksheet to another?
Excellent!
You're more than welcome!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Re: A formula using the quantities contained within a drop down
Hi @laurenceharper,
I've solved it! 😃
There were two issues.
I changed the date in the main sheet in the Funds Received Date column.
- The date used in the main sheet was not included in the range in the Source.
- The Q1 range had a date not available in 2022, (February 29)
Make sense?
Did that work?
Re: INDEX MATCH A PARENT
Try matching on the product name instead of the inventory ID.
Re: Check Box Column Property Not Working
I've run into this before when I added new rows to a sheet and everything in the new row was blank. When you add something to one of the columns in the new row the checkbox will appear.
Re: Change parent symbol based on children symbols
All symbols have a text value that allows them to be referenced in formulas. I went ahead and looked up the symbols you used and found this:
In your case you would need to replace "Red" with "No", "Yellow" with "Hold", and "Green" with "Yes".
NOTE 1: This is case sensitive. "no" will not work, but "No" will.
NOTE 2: All symbols will have different text values. You can find them by clicking on the dropdown arrow in a cell after setting the column type as the symbol of choice.
Re: Averageifs Question
Try this instead...
=AVG(COLLECT([Reception Desk Staffing]:[Reception Desk Staffing], Month:Month, OR(@cell = "January", @cell = "February", @cell = "March")))
Re: Average formula for text field
I image the intended outcome is to have it read "Closed Complete" if there are more of those and "Closed Cancelled" if there are more of those, right? if so, you'll want a nested if() statement instead of an avg().
try something like
if(Count("Closed Complete")>Count("Closed Cancelled"),"Closed Complete", if(Count("Closed Cancelled")>Count("Closed Complete"),"Closed Cancelled","Something Else"))
E.G.:: if there are more "closed complete" than "closed cancelled," say "closed complete," otherwise; if there are more "closed cancelled" than "closed complete," say "closed cancelled," otherwise say 'something else."
Re: Is One Of (multiple contacts) field
Hi @palmcitytim
If you're searching for one value within a multi-select cell, you can use the HAS function!
For example, something like this:
=COUNTIF({Multi Select Column}, HAS(@cell, [Single Name]@row))
If this hasn't helped, it would be useful to see a screen capture of each sheet, identifying what you're looking to do, but please block out sensitive data.
Cheers,
Genevieve
Re: Pulling data from one smart sheet to another to create chart on results
I'm not sure I follow. Are you looking to pull one row for each unique instance and then add a count for each of them?