-
Formula Assistance (COUNTM??)
Hello all, My team and I are hoping to build a formula to do the following: First, identify all items that belong to "Group A," then count how many items the rows that belong to group A have in "Color." So, for example, the answer for this would be 4 (because there are 4 items in the "Color" column that belong to Group A).…
-
workflow to be triggered when cell is changed to specific value
Hi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!
-
Is there a way to automatically share editing access to underlying reports?
I have created a dashboard and would like anyone with access to be able to add information on rows in the underlying reports that are embedded. I'd prefer to be able to do this without adding each individual to the workspace. In WorkApps, I can share all reports, but I only want them to see the dashboard. Any/All ideas…
-
How do I auto-save a sheet without opening the sheet?
I use conditional formatting. When I review the dashboard, the formatting doesn't update until I go to the sheet and save. I would like the sheet to save automatically when conditional formatting makes changes. Thank You.
-
Usability Problems on Big Sheet
HELLO I HAVE AN USABILITY PROBLEM CURRENTLY OUR MAIN SHEET (ADMIN_2021) IS ONLY USING 41% OF CAPACITY, ACCORDING TO THE REPORTS OF EACH SHEET. INFACT WE HAVE 204.000 ACTIVE CELLS TO DATE (CURRENTLY USING 51 COLUMNS AND 4000 ROWS ) I AM THE OWNER OF THE SHEET, WITH A TOTAL OF 3 ADMINISTRATORS, 4 EDITORS, AND 2 OBSERVERS.…
-
Weekly Comparison
Hello guys, I am trying to add a column that will provide me a %complete for previous week. I have this week's percentage and a PM is updating that weekly however I was wondering if there is a way to have another column that would be updated with previous week's percentage without the manual labor (think of 300+ rows). Is…
-
Auto Label Parent Rows
Hello! I'm looking for ways to automate labeling the parent rows for an onboarding sheet. I want to automate the label of the day so that I won't have to manually adjust it every time. Here's a sample a screenshot:
-
Publishing and Google Search indexing and crawling
Business and Enterprise users can publish a sheet, report, or dashboard. My question is can these pages be discovered by Google Search indexing and crawling? These are the options I refer to: I looked at the page source on a sheet I published. The HTML code contains no noindex tags in the header. And the Developer tools on…
-
VLOOKUP/JOIN/COLLECT - Need help combining groups of emails
Good afternoon, I am stumped & hoping someone can help. In short, I have a Reference Sheet with the contact info and a Communication Plan Sheet. In the Reference Sheet, I added an Address/Filter/Email List column. The Email List is grouping all of the addresses based on which group they are in, so when you copy the Email…
-
Require Help with COUNTIF Formula on Smartsheets
Hello everyone! I am trying to count the number of records for the current year(2021) from 'System Generated' date column -(Request Date )with formula - =COUNTIF(Request date: Request date, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) in the 'Sheet Summary' section. This is not working - says #UNPARSEABLE Alternatively I have…
