-
Checking Some Children Rows but Not All
Hi everyone, I'm somewhat new to Smartsheet and I'm still learning about formulas and functions. I have a parent row and 4 children row. If all 4 children rows are checked, that's great but it's most important that the last 3 are checked in order for the parent row to automatically be checked. I set up a function.…
-
Scientific Notation
Is there away to get smartsheet to recognize scientific notation in order to add, subtract, multiply, divide, etc.. Thanks
-
SUMIF a field if box unchecked
I'm trying to sum a column, [Total Commission], if [Rep] is ES and the [Rep Paid] column does NOT have a check mark. It's looking like this so far: =SUMIFS([TOTAL COMMISSION]:[TOTAL COMMISSION], [SALES REP]:[SALES REP], "ES", [REP PAID]:[REP PAID], ??? (this is where I get lost.) Help?
-
Status Change if Column Checked
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below) Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from…
-
Formula returning a blank cell
I have been trying to figure this out for hours with no luck. We've created a formula to automatically update our status column in our project plan sheets. We have specific parent rows that are designated as milestones. The milestone row status cells should update based on the status of the child rows. A milestone row is…
-
Flag if date created > 48 hours and completed column is blank
Hello, I'm new to using SmartSheets and first time poster here. Hoping you can help me with an elegant solve? I'm trying to create a function where a row will be highlighted when it satisfies two criterias: 1. if the date created has been more than 48 hours 2. and completed is blank (not marked with a date) Basically in…
-
Formula wont work.
Hello, I am trying to use this formula: =IF([Column2]5="","",(IF((VLOOKUP([Column4]5,'Combined Timesheets'!A:[Column2],2,FALSE))=[Column2]5,"Yes",""))) It wont work and I keep getting the #UNPARSEABLE error. Can anyone help me fix my formula?
-
Problems using IF formula to calculate status
Hello, First post for a new Smartsheet user. I'm trying to do an status formula. If my % Complete column is 0% then the status should read "Not Started", If the % Complete column is 100% then the status should read "Complete", any percentage in the % Complete column that is not 0% or 100% should read "In Progress". I'm…
-
Nested SUMIF+cross sheet formula
I am struggling with a formula. I have two sheets. One is a list of proposals, the other is a material forecast roll-up. I am trying to build a formula that will sum up the square feet noted for a particular product within a certain month and year, but I can't seem to get it right. Here is what I have so far:…
-
Range name
Hi everyone, I have a question about the range name and description. When I use formula with another sheet it calls automatically like {range Count}. Later, when I try to find out, which sheet data is being used in the formula, I can't find the sheet and range because I just forgot it and it is not mentioned in the range…