-
CONTAINS in COUNTIF referencing to another sheet returns #UNPARSABLE.
I want to count all the cells with the word "Exempt" in the Column/Reference {Stat}. Using the formula below gives me the #UNPARSABLE error. =COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt",{Stat}) =COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt",{Stat}@cell) =COUNTIFS({BIN}, [BIN #]@row, {Stat},…
-
Nag an approver?
Is there a way to send a repeat approval request if the initial request goes unanswered? Kind of like a, "while 'Jane Q. Ceo's' approval status is 'Submitted' send an update request once a day." Then, of course, once it changes to approved or declined, the notifications stop. It seems like all of the notifications or…
-
Field I'm on goes into edit mode and wipes out data
Hi, I have a problem that I can't figure out. In Project Plan and other apps, sometimes the field that I'm on automatically goes into edit mode and wipes out data. If I don't notice and move off the field, the value gets wiped out. I've lost valuable data multiple times. If I reboot my computer, the problem goes away at…
-
Is there a way to highlight values by month or display values by month in a gnatt view?
The screenshot above is done in EXCEL, and its calculating the allocation% percentage of each project by month for an individual. It also has a blue bar that highlights the months that have values in it. I am trying to replicate this in smarthseet and I am not sure the best way to approach this or if its even possible to…
-
Helper column to determine parent, child etc
Hello I'm trying to create a formula which will assign a 'level' in a helper column based on my indented rows. I've done this manually - is there a formula which will do this for me?! Many thanks in advance!
-
Count Between Two Dates with Other Criteria
Hello, I need to calculate the number of days between two days on another sheet when the name@row matched the person who created the entry and the dates are between my beginning and end dates on my sheet. Here's an example, John enters a ticket with a service date of 3-1-22 and an activity date of 3-4-22. I need to…
-
How do I setup an Approval Workflow automation where the approvers can vary?
I am trying to design an automated approval workflow where there could be anywhere from two to five approvals needed. The five individuals are constant, except where certain invoices might only need approval from Manager A and Manager E, others might need B, C, D, and E. I have setup checkboxes for each manager and a…
-
Keep Parent and children rows together
I have a list of locations that each have children rows with different services, i want to filter and sort by the parent row and keep the children underneath each parent. For example if i want to sort by state, county responsibility etc
-
Prevent Overwriting of "Handler" Column
Hello, We have a smartsheet for our support team to claim requests submitted. As of now, when a form is submitted- every member of the support team receives an alert. From there, one of them must enter the sheet and elect themselves to handle the request (dropdown field with their names). We've run in to an issue where…
-
Reports, Group and Summary options
I realize that the primary column must be viewable (unhidden) in order to see the Group and Summary titles when using those functions in a report. The issue I am running into is the name of the Group and/or Summary is a bit long. In order for it to fully display, the column must be very wide. Any ideas on how I can "merge"…