Formulas
Discussion List
- 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…
- Hello I am trying to set up a sheet reference based on two criteria (Center and Department). I have tried the index/match and that did not work, so I tried multiple variations of the index collect-- b…
- I am attempting to use JOIN to build a query string and I am able to do it however if the column I join has spaces in the entry, the JOIN only attaches the first word until there is a space. =JOIN([Jo…
- Hi all, I have tried various different formulas from various posts on here but still keep getting Unparseable. I am trying to create a formula, linking from another sheet, to find the following criter…
- The following formula is #UNPARSEABLE. I'm not sure why. Please help. =IF(MONTH(TODAY())>=7, YEAR(TODAY())&"-"&(YEAR(TODAY())+1), (YEAR(TODAY())-1)&"-"&YEAR(TODAY()))
