-
Re: If/Then formula with two options based on a date?
@jmhoward You can use and IF function for what you're trying to do. Assuming Active and Inactive are the only options, the below formula should work. =IF([Audience Campaign Status]@row = "Active…1 · -
Re: COUNTIFS- CONTAINS/FIND/HAS
@ka36 I used this in a test sheet, it seems like it's working, you need to use @cell, not the range reference again.1 · -
Re: What's the easiest way to grab all specific JSON data from a Smartsheet JSON?
@DougSmartsheetDev I don't use Python for this, so I can't give you specifics on that, bur from the API side you'll use a GET at https://api.smartsheet.com/2.0/sheets/<<sheet id>> to pull…1 · -
Re: Time Triggered Automation with Conditions
@Lynae Glad that worked for you!1 · -
Re: IF And Formula Not Working
Actually I see the issue. Try this: IF(COUNT(COLLECT({StartDate},{StartDate},<= [Punch Date]@row, {EndDate}, >=[Punch Date]@row))>0,1,0) The reason your formula was giving you the error is b…1 ·