-
Sheets exiting folders overnight
Hi all! Wondering if anyone else has this problem. I have all of my sheets organized nicely in folders. Many of the sheets are shared (but not at the folder-level). Some days, I log on in the morning and everything is as I left it: Some days, I log in and some of my sheets have decided to sneak out of their folders into my…
-
Counting Distinct Contacts in a Contact List Column
Hello. I have a tracker and in it I am using a Contact List for "Assigned To" and I allow for that to contain multiple contacts. I am trying to count the number of distinct individuals in the column to come up with a total number of contributors to the effort we're tracking. I used: =COUNT(DISTINCT(Leads:Leads)) The result…
-
Auto-Number/System field Created (Date) changes back to "Date" field
I have an Auto-Number/System field called "Date Submitted" as Created (Date). This is used on the manual form (which we are phasing out) and also to capture any new rows that come in from Salesforce sync. For some crazy reason it keeps changing column properties to Date. In which case two things break: Anything that syncs…
-
Help to show Gantt View horizontally rather than stacked
Hi everyone. Any thoughts on how I could accomplish this (or if it's possible at all)? Thanks.
-
How to Limit Access to Smartsheet
I know this question likely goes against all that is Smartsheet, but... We have a sheet setup to take submissions from a form. When a new row is added, a contact in a column is notified. After the row's status is still "in progress" for 3, 6, and 9 days, the contacts get reminders that these rows are still "unresolved" and…
-
If all = Competent then competent, if not, then inconsistent
Hi all, I need help with a formula. People choose their skill based on a certain topic: Competent Inconsistent Expert I need a formula that looks at all the children and determines that: If 1 inconsistent, no matter what else, show as inconsistent If all competent or expert, show as competent I am guessing it can be easily…
-
Dynamic Views & Dashboards
Can you add a dynamic view to a dashboard for easy access?
-
COUNTIFS Unparseable
I have two formulas that are currently returning correct values, but I want to combine them and only return the count if both criteria are fulfilled: =COUNTIF({Approved Avalara Fixes - Form Required Range 1}, "Name") =COUNTIF({Approved Avalara Fixes - Form Required Range 7}, NOT(@cell = "Child")) Above are the two formulas…
-
Help With Collect Function
I have a sheet that has three columns - DueDate, Status and "Status by Color" respectively. Based on the entries in the status column the "Status by Color" cell is assigned the color Red, Green or Blue. My need is to identify the 5 oldest 'overdue' dates within the DueDate column. I achieved this using the following…
-
Update Sheet 1, Based on Submission to Sheet 2
I have a quick question. I have 2 sheets (Sheet 1 and Sheet 2). In Sheet 2, users submit a form and a field (which is hidden) is automatically checked indicating it's been submitted. What I'm wanting to do is - essentially - notify Sheet 1, that a user submitted something on Sheet 2. My first thought, is to use a VLOOKUP…