-
Formula to capture count onto dashboard
I am attempting to create a chart on my dashboard that shows how many reports an individual has completed within the year. I created a new sheet, and use the =countif formula within the cell but keep getting an #UNPARSABLE error. I reference another sheet where the data lives, selecting the column where the assignee is…
-
Conditional Formatting Issue for column formula
Hello all, I am having an issue trying to use what should be 'basic' conditional formatting for percentages in a column in my sheet, where there are no colors being displayed as intended. Green = 55% or below Yellow = 55% - 109% Red = 110% + The column the cond formatting is referencing is using a formula - I wasn't aware…
-
Need formula to show row ID/link in a cell
Hey team, trying to find a way to populate a row id or row link in the cell. Is it possible?
-
Formula to track training by hours and minutes not days
We need to track all training by hours and minutes, not days, and I can't find a solution to be able to calculate this with a formula. Anyone able to help? Thanks!
-
#INVALID VALUE with date formula
Hi there, I have a sheet with 3 date columns - one for inputting the date when a QC investigation was opened, one for calculating a deadline for QC which is 1 month from the opening date, and one for calculating a deadline for QA which is 1 month plus 15 days from the opening date. In certain instances the formulae are…
-
What's your Best Error Checking Column Using Formula?
I have discovered multiple ways to create a error checking column that looks in all columns to see if there's a broken formula somewhere. However, all the ways I have found aren't very elegant and don't provide the type of details I want. Example: =IF(ISERROR([First Column in Sheet]@row:[Last Column in Sheet]@row), 1) This…
-
How to get my numbers to correctly add up?!
Hello everyone, I am tasked with tracking budget moving forward and would like to be able to track overall budget but also budget for each POs. I would like to have the formula to add the Children's Children's (if that makes sense) and ignore the Total of the PO. This way I can have the total of the PO's in one line but…
-
Smartsheet summary formula
Hi All I am trying to create a smartsheet formula for the Summary field that will return the maximum someone in a Senior Quantity Surveyor role is being paid currently in the company, plus the name of the person. I have the max salary part sorted - =MAX(COLLECT(Salary:Salary, [Job Title]:[Job Title], "Senior Quantity…
-
Formula to count days past a certain date without weekends
Hi! I have a sheet where one column has a submission/end date ("END DATE: CA Exam 4 Part 2") and another column is a "due by" date ("E4 Window Closes"). I have a column that I keep hidden which has that "due by" date ("E4 window closes") to help in the formula I have running: =IF(AND(ISDATE([E4 window closes]@row), [E4…
-
Formula that returns a value equal to every other day
Date formulas are the most challenging for me. The requirement is to provide a visual calendar that will trigger the quality audit team to complete the audits expected for the current business day. The sheet has three frequency options: Daily, every other day, and weekly. I am struggling to determine the formula for every…