I am trying to write the formula correctly, I have a couple different versions and neither are working. I can get the first 2 parts to work in this version, but the last part fails giving me INCORRECT…
Hello, I am using an IF formula to generate numbers but it doesn't seem to work when i have numbers over 10,000 and it just spits the same number back out. See below: the formula I am use is: =IF([col…
I am attempting a complex formula that will link two SmartSheets. (See below for screenshots) SPAR Review Testing: Uses a form to collect document submissions. This sheet has a submission date column.…
Previously, Row 1 of my smartsheet contained the column's name. This way, I could write a JOIN(COLLECT) formula to return the column's name if certain conditions were met throughout the sheet for that…
I'm likely missing something simple. I need a sum where the referenced column is either not "No" or if it is blank. The not "no" is easy, it works fine. It's incorporating the isblank that is kicking …
Hi! I am looking for some help in creating a formula where if a certain word is found in one column, another word is returned in a second column. For example if "Head", "Nasal", or "Spine" is containe…
need help with this simple formula for a sheet summary =COUNTIF([IEP Status], "NEW (not signed)", "Active", "Active (Needs Att.)") something is wrong with the formatting I want to count number rows th…
My manager and I have been trying to find a formula that would calculate the FY quarter based on the "Start Date". We haven't been able to use a lot of the formulas we found on the Community because o…
Hi there, I have two sheets and I am trying to use Index/Match to pull multiples values in a cell in Sheet 1, into another cell in Sheet 2. I'm using the following formula, but I'm only getting the fi…