-
Reports using HOURS past Creation Date/Time Criteria
Hello friends, I need to be able to create a REPORT where the only rows that appear are those that are equal to or greater than 3 hours past the Creation Date/Time. Is this possible?
-
Counting Multiple Columns with different criteria
Hello! We manage properties with under different statuses (Available, Expired, Under Contract, etc.) and use another Column called "Dead" to filter our reports. We created a checks and balance sheet to view the counts at a glance for high level overview, and we are unsure how to use the =COUNT and =COUNTIFs on two columns.…
-
Sheet Summary when Request Owners Varies
Hello, I am trying to add a count of Request Owners to a dashboard. The Owner varies and I have not figured out a way to have new Owners appear. How do I include them on specific Owner Count on my dashboard. Is this possible? Thanks
-
IF/INDEX/MATCH?
I'm trying to create a formula for an on-boarding tracking sheet. -There is one sheet for each new hire. The first row contains info about the new hire, including a column *Position*, which has a single-select dropdown with five position types: "Staff", "Academic Staff", Temp/contingent", "Postdoc" "Faculty". -Remaining…
-
COUNTIFS Description
I believe the description of COUNTIFS is misleading and basically just incorrect. It does not properly describe what it actually does. It says it counts the number of cells but it doesn't. It counts the number of times all given conditions in their respective ranges are met. One match of all given conditions in their…
-
Can we assign clients and link their info line to staff's individual work sheets?
We have a master list that talent inquiry forms populate and notify a manager. Once the manager assigns that client inquiry to a staff member, we would like to have it copied to their personal work pages. These pages then need to stay linked to the main page in order to keep updated notes, attachments, and status accurate.
-
How to utilize a Checkbox with multiple Options
Hi, I know this is really simple but clearly it is Friday and my brain is no longer working. I am trying to have a checkbox automatically check if the Finding is "Non-Compliant" or "Partially Compliant". I am able to get the functions to work when just choosing 1 option but when I combine it does not. =IF([Finding:…
-
Formula from Excel Help
Hello community, I cannot figure out why this formula is #UNPARSEABLE in Smartsheet when it works perfectly in Excel. The intent is to show the amount of days left before/after "Due Date" [Column5]. EXCEL =IF(E2="","",IF(E2<TODAY(),-DATEDIF(E2,TODAY(),"d"),DATEDIF(TODAY(),E2,"d"))) SMARTSHEET…
-
Question on assigning a qualitative value based on quantitative info from members of the same group
Hi, I am looking for help on crafting a formula that would allow me to discriminate between [Type] -> "Dna/Seq". Right now, I know that they are either DNA plate barcodes, or Sequencing plate barcodes based on the "pcr" prefix. However, I would like to be exact with these and say it is either DNA, or Seq. It is fairly…
-
Formula from Excel Help
Hello community, I cannot figure out why this formula is #UNPARSEABLE in Smartsheet when it works perfectly in Excel. The intent is to show the amount of days left before/after "Due Date" [Column5]. EXCEL =IF(E2="","",IF(E2<TODAY(),-DATEDIF(E2,TODAY(),"d"),DATEDIF(TODAY(),E2,"d"))) SMARTSHEET…