-
Use a form to lookup sheet data that and add content to it
Hello, I have read the forms with the “VLOOKUP” and “LOOKUP” functions. I am new to smart sheet, but not to excel formulas. I have an associate inspecting carts for wear and tear items, this is working well with check boxes and the photo attachment is awesome to have. Next step is the associate that repairs the cart, I…
-
Check In/Out inventory log
Hello, I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pack for each event. I count the giveaways that come back after the event, and I need a way for this to reflect the number…
-
Index Match with some data returning as Invalid Data Type
I'm using an Index match to pull a certain number. In this column I will get a successful return of a few number then the Error then more correct numbers. Thing is, they are all pulling from the same data set (from an API), and using the same parameters and search values. Why am I getting the Invalid Data Type error?
-
Creating a Master Project List and Dashboard
Hello, I would like some help in designing a Master Project List, and a Master Project Executive Summary Dashboard. We have a Roadmap that contains each functional area's main projects/initiatives. Is there a way I can build a formula to have all the information from each road map combined into one Master Roadmap... Which…
-
Formulas
I have a formula that is working in most of the cells. However the number is not showing and the formula is in the cell. I am not sure as to why it is not showing up with a value. Here is a copy of the formula. =IF([project name]1 = "", "", IF([PanAm proposal needed by]1 = "", JOIN("it's been ", TODAY() - [quote request by…
-
Help on formula: Countifs with multiple columns and criteria
Hi, So I've been working on a formula but couldn't get it right. I wanted to count the number of my projects that are Active (on-time) and Active (delayed). I get the on-time count correctly but for the delayed ones I always get a plus 1 in the results. Here's the formula I use (btw the stages represents that a project is…
-
Help with my formula
I am not the best at formulas and need some help. I cant seem to get my head around building formulas. Anyway can someone help please. I am trying to build a formula that will count all the true BOOLEAN in the children row and when it is greater than 4 return the a true outcome to the parent row. Hoopefully someone can…
-
Numbers and Text in the Same row/Column
I have some writing that is not showing in a row/column when I have a formula to say so. Is there a way to get this to populate with both? Here is the formula that works: =IF([project name]14 = "", "", IF([PanAm proposal needed by]14 = "", JOIN("it's been ", TODAY() - [quote request by customer]14, " days"), IF([PanAm…
-
#UNPARSEABLE Formula
I am trying to get this formula to work correctly in final calculations of a project we are working on. =IF([Column3]2="","",IF([Column17]2="",CONCATENATE("it's been ",TODAY()-[Column5]2," days"),IF([Column17]2-[Column16]2<0,CONCATENATE(-([Column17]2-[Column16]2)," days to spare"),CONCATENATE([Column17]2-[Column5]2," days…
-
IF Function
I want to create an IF condition where if a cell contains a symbol on another sheet that equals "New" then populate that value otherwise, leave it blank. I have this formula: =IF({New Applicant(s) Range 1} = "New", {New Applicant(s) Range 2}) According to what I've read in the HELP, the False condition is optional and if…
