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…
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…
Hello All, I'm in Operations at a nonprofit. I am hoping for assistance in building out the Template Set for Objective and Key Results (OKR) Tracker. The template set is built for 5 objective. I need it built out for 12 and I am running into difficulty connecting cells/sheets and formatting. I have a blank copy. If someone…
Hello, I would like to add a formula for the partners' cell(image #1) to reference the two columns in another sheet (image #2). The current formula you see in the first image only references the Partners(existing) column. Any help is deeply appreciated!
I have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that counts the number of times their email address is in the Contact column. However, the…
I am tyring to make an ERP system. I created workflow to approved from the purchasing department and its department's manager with email. However, i want to add multiple items in the same time and same form to approved(in item code column). How can it possible ? I tried multi select dropdown but workflow does not work.…
I am tyring to make an ERP system. I created workflow to approved from the purchasing department and its department's manager with email. However, i can add multiple items in one time to approved(in item code column). How can it possible ? I tried multi select dropdown but workflow does not work. Thanks.
I created a scheduling system using a grid/form/dashboard. After implementation I found out that forms do not have any permission settings. Ex. I had a grid/form that I only want 10 people to access, the grid is restricted but everyone can access and submit using the form. For this project to be successful, I either need…
Good day everyone! new to smartshets and hoping to get some help. Is there a way to have an automation that will recognize multiple values (ie: ABC = Gabby, BCD= Debbie) or do I have to create an individual automation for each value?
