jessica.smith
jessica.smith
Reactions
-
Re: Column formula syntax isn't quite right?
@LeoCicio The issue is that you can't convert a formula with an absolute cell reference into a column formula. Your options are: 1. To change Smartsheet1=1 to Smartsheet@row = 1 if you want to base t…1 · -
Re: Allow Count Unique Values Only In Report Column Summary
@Alan P. Thanks Alan! I've figured out a few different ways to do this at this point; however, I still think it would be a nice built-in report feature.1 · -
Generate list of current group memberships for a given user in Bridge
I would like to be able to make an API call in Bridge to generate a list of all groups/groupIDs that a user is a member of. To my knowledge, this can only be done for me as the "current user&quo…2 · -
Re: Can you have two "OR" functions within a COUNTIFS formula?
@Devin C. Try taking the Project Status values out of quotes (e.g., @cell=1 instead of @cell="1"). I think Smartsheet is having a hard time with string vs value in this particular formula =…1 · -
Re: Formula for counting if cell has RYG symbol
@smartsheetuserucb1 Try =COUNTIF(Status:Status, OR(@cell = "Green", @cell = "Red", @cell = "Yellow"))1 ·
