-
#DIVIDE BY ZERO Error - other resolutions not working
I am trying to resolve a #DIVIDE BY ZERO error. I've seen the other resolutions, but they are not working for me. Here is the formula that I am using: =ROUNDUP(([Anchor Install Hours]@row / {Amazon - Brownfield - Priority Sites - Set Range 2} / [# Anchor Technicians]@row), 0) I tried the IFERROR(ROUNDUP resolution and that…
-
Cartesian Product
Hi Everyone, I have two sheets that I want to merge into a 3rd sheet and want to create a cartesian product in the 3rd sheet. I can't find a way to get this done, has anyone tried this before? Thanks
-
Adding an ISBLANK
Hi there, I have my formula that works but forgot I needed to add a clause for when a column cell is empty so it doesn't return an error, which I'm hoping will allow me to make it a column formula without too much fuss. I'm trying to use ISBLANK as that seems like the best option and I just can't see the problem but it…
-
RAG = Date Range formula?!
Hi, I'm setting up a sheet to keep a track of training and re-training needs. I need the RAG status to change according to the date range, e.g.: Person A | Training Due Within 90 Days of Today | RAG = Yellow Person B | Training Due Anytime Over 90 days from Today | Rag = Green Person C | Training Overdue from today up to…
-
Looking to see the Sum based on what is in another column
We are trying to move all of our excel sheets into smartsheets and we have one sales tracking sheet we are looking to have automated. The columns are Salesperson, Month, Expected Sales. What we want to see if Month equals March what is the Sum of the Expected Sales for those Salespersons. We want to have this automated so…
-
Help figuring out which formula to use
Hello! I am fairly new to using Smartsheet and need help figuring out if what I'd like to do is even possible and what formula I would use (would it be index/match?). I would like to pull information from one sheet to another sheet. What I am trying to come up with is: IF the "PRINTER" ON PRINTER LEAD TIMES sheet is the…
-
How to count children cells from % complete column - countif not working
This is for my % complete column. I'm trying to count the children tasks if the % Complete is less than 100%. I'm using this formula: =COUNTIF(CHILDREN([% Complete]):([% Complete]), <100%) but it is not returning a count, just displays the formula as it isn't correct syntax but can't figure it out. Thanks in advance!
-
Looking for a Formula that will count if multiple values are true
I am working to keep track of under represented minorities we have in our classes. We are able to get a formula that keeps track if they belong to one Like Hispanic or American Indian, but we do have some students who belong to more than one of these group. We use this formula for Instance to gather if they were Hispanic…
-
Cross Sheet Joining Automation
Hello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. I am hoping to implement a checkbox that initiates a purchase request next to each item. My initial stab at this is when…
-
What formula can I use to calculate years/months/days of service?
Hi there experts-- I'm currently using this formula to calculate employee length of service, but it is adding the months and years together (so the total years are too high): =ROUND(ROUND((NETDAYS([Hire Date]@row, Today@row) / 365) * 12) / 12) + "yrs " + MOD(ROUND((NETDAYS([Hire Date]@row, Today@row) / 365) * 12), 12) +…