-
Re: If statement that takes a column value and if meets a criteria, subtracts a number
=IF([Apply TCC]@row=1,[Quote before TCC]@row-200,[Quote before TCC]@row) *Lol i had this window open in a different tab since this morning, didn't have that paul already helped sorry1 · -
Re: Same Team Member in Multiple Groups
highest level of access of the given permissions1 · -
Re: Trying to Copy the Result of a Formula to a new Sheet to then use in a different Formula
shouldn't need to do the text parsing listed in the article. You can wrap either the formula outputting the '5 or the reference to the '5 with value.1 · -
Re: IFERROR AVG
ok, I misunderstood then. for this one it's probably better to break it down into parts. =avg(iferror(sum([goal 1]@row)/sum([achieved 1]@row),""),iferror(sum([goal 2]@row)/sum([achieved 2]@…1 · -
Re: Meet Paul Newcome, our August Member Spotlight! 🎉
aaayyyy let's go @Paul Newcome !!!3 ·