Formulas
Discussion List
- We use forms to get information from our colleagues and we would want to send them a form prepopulated by their inputs so they can update the information if there are any changes. This would be very u…
- Hi All, This one may not be possible, but will drop it into here to see if it is, thanks in advance for your help. I have a "COUNTIF" Statement in place which is counting the number of times "Red" is …
- Good day everyone, I've seen a lot of posts about changing a symbol based on the date, but none for the other way around. In my use case, I have a Priority symbol that is being filled in on a form. I …
- I created a sheet that has a primary column for "product type" and additional columns with months listed for the next two years (Dec '20, Jan '21, Feb '21, etc.) which indicates the month in which tho…
- I have a few sheets where I am needing to have the data Presented with the individuals name, then the email address in the column next to it. I have come across a few articles that have suggested havi…
- Hi It would be really awesome if we could use the "Attachments, Comments, Proofs and Row Indicators Columns" in Formulas. Just as a reference point. "Like Helper Columns" Example, if there is a update…
- I am trying to create a formula that references another sheet and totals the number of times a specific value shows up in a column that allows multiple values (from a dropdown menu). I am using =COUNT…
- This is the formula I am using: =VLOOKUP([ANALYST PARTICIPANTS]@row, {SAFFS::Firm:Analyst}, 2, false) I have a separate Smartsheet that has a list of Firm/Analyst names that I used Data Shuttle to mak…
- So, a simple formula (that worked before), is now not working: =COUNTIFS([Approved 2024 $$]:[Approved 2024 $$], "", [Targeted Area]:[Targeted Area], "Atopic Dermatitis") Even if I reverse the [Approve…
- I have SCC setup to provision projects. Inside the project plan there is a variety of data coming from the intake sheet that will be used to determine what duration to pull from a separate master lead…
