-
Can I hide the weekend days for a task?
I have a task that spans a weekend. It does the correct calculation for the correct number of working days, but in the calendar it's a bit misleading for our team. It makes it appear as if the task is being worked on during the weekend. I would rather have it only displayed for the 'working days' per the calendar settings.…
-
Creating custom "enterprise managed metadata" column types for use in multiple sheets?
Hi there, Is there a way to create a new custom column type? For example, I'd like to create a column type "Department" which would be a drop-down that would be populated with a managed list of official department names. Ideally, this list of departments would be managed in one location, and then if any department names…
-
How To Identify Max Value
Hello, Need help, I want to identify which questions have the highest "No" respond. On column "MAX - NO" will appear the name of the questions that have the highest No respond. Currently, I can identify the maximum of respond on each questions. I don't know which suitable formula to combined with MAX to capture which…
-
Raise Flag: If and statement
Trying to put in a formula that raising the flag if the end date is past the deadline and status is not marked as complete. This is the formula I have =IF(AND([End Date]5 > Deadline5, NOT(Status5 = "Complete"), 1, 0)) but it is returning #UNPARSEABLE
-
IF Formula (Due Date > Today's Date AND Request On Hold (Box Checked) = No Flag In Past Due Column)
Hello, I am trying to troubleshoot a formula to achieve the following outcomes. Outcomes: If the Due Date column is past today's date, trigger a flag in the "Past Due" column. HOWEVER: If the "Due Date" column is past today's date AND the "Request On Hold" column has a check box, NO flag in the "Past Due" column. Database…
-
Need a report that summarizes clients assigned to staff
I have a very basic Smart Sheet: Staff Member (Contact List) Client name (Text Column) Age (Date) Birthday (Date) There are a few other columns, but they are not relevant to my question. I need to be able to run a report that summarizes the number of clients assigned to each Staff Member. I don't need to know anything…
-
Giving users access to only their assignments on a sheet/report
Hello, I have a commission sheet set up to payout multiple agents and I only want the user to be able to access and see their payouts. Is there any way to share a sheet where the logged in user (free user) can only see what was assigned to them? I know I can do this on a report but the sheet still needs to be shared in…
-
Help with adjusting a formula
So the formula below is used to determine the colors of the dots. However, I need it modified so that for Blue Dots, they will be Blue based on the current condition already there, or if the start date or finish date are empty. I was unable to figure this out on my own so thought I would post it here =IF(OR(Status@row =…
-
Counting (and Averaging)within Columns
How do I create a Counting formula to count how many times an Owner Email created a Title on Create Date? Is it possible for me to add the average Score to that count? Example: 3 = anisiac (owner email) created Workforce Management Opp (title) on 1/13/2020 (create date) 91 = Avg Score
-
Need help creating a formula
I do a project status report for my team. We currently have status options like: "Not Started" , "Active", "Active + Concerns" and "Complete. I recently made another status option: "Cancelled - Covid19". I make a dashboard for my supervisor that highlight the number of projects that aren't complete due in the next 7 days.…
