-
Vlookup #UNPARSEABLE Error linking to separate sheet
I get an #UNPARESABLE error message for a vlookup I am trying to create to a separate file in SmartSheet, I suspect there is a problem in the syntax. I've tried multiple tweaks to this formula with no success. As a check I exported the SmartSheet and the external file to Excel and had no problem successfully creating a…
-
CountIfs resulting in "0"
Similar to my previous post, I'm now running into issues with CountIfs returning zeros when I am referencing multiple columns from a separate sheet. I am trying to figure out the number of "Risks" and "Issues" that are marked as state "Complete" each week. I was able to count how many risks and issues have occurred each…
-
Countifs based on current month turnaround times
Good Morning! I am trying to create a graph based on the current month's turnaround times. I tried the following, but it returns as #Unparseable. =COUNTIFS({Turnaround}, <=3, {Date Fufilled}, Value(@cell) = Month(Today)) Is this even possible? Thanks
-
Calculate due date based on last reviewed date
The policy was reviewed on June 1, 2019, I want the next due date to be in 365F both columns are date fields Formulas I tried- =[Column4] + [365] = Reviewed Date + 365 fx=Reviewed Date + 362
-
COUNTIFS for year within criteria
I am pretty new to using formulas. I'm working on a dashboard for one of my sheets and I want to show how many escalations a plant has had this year alone. Here is what I have so far: =COUNTIFS(([Plant]:[Plant], "Changzhou"), IFERROR(YEAR(@cell), 0) = 2019) I've tried many different variations based on my scouring of this…
-
Add lines in templates and have the formulas auto appear
Hi, So I created this template for our sales team. The idea is that in the yellow boxes they enter item number and quantity (and other things based on where they are in the template) and was informed that there are some sales orders where they will need to add additional boxes. We were looking to have it set up so that one…
-
CountIfs between sheets resulting in "0"
I have a pretty extensive risk log spreadsheet that I am trying to condense and simplify. Specifically, I want to filter it into a new sheet that will show me the number of risks and issues coming in per week based on the date they were entered into the log. I have been attempting to use the "Countifs" function, however I…
-
Need help correcting RYGB formula ASAP
My colleague set up a formula I'm using for RYGB column and I need some help interpreting it to figure out why it isn't behaving exactly the way I want it to: =IF(ISDATE([Actual End]@row), "Blue", IF([Working Start]@row > TODAY(), "", (IF([Working End]@row < TODAY(), "Red", (IF(ISDATE([Actual Start]@row), "Green",…
-
Document Checklist(s)
Hi all I am looking for the best way to create a document tracking checklist that tracks all necessary documents in our loan origination process for EACH applicant that may be on the loan. There could be 1 applicant or there could be 5. We could have individuals or entitys on the loans as well. I need to be able to pull…
-
Formula to checkbox when option selected from dropdown
Hello As per the screenshot below, im trying to have a formula that if Status A is selected from the column this will check the box within approved for construction. is this possible. Regards Daniel