Trending in Formulas and Functions
IF/OR Formula Error
I created a formula to populate a field based on the status of various other fields. I got it to work with two conditions (Approved or Declined), but when I add the third (Submitted) with the false response of blank (""), I get an error. Please see the formula below - I assume I messed up something really easy :)…
Average CTR by Type of Ad by Year with DD/MM/YYYY Format
I'm looking to average the click through rates (CTR) by type of ad for 2023 in the SmartSheet Summary Sheet section. There is data from 2022 and 2024 on my sheet, so I'm trying to make sure the data is only calculated between 1/1/2023 and 12/31/2023. I'm using the AVG and COLLECT formulas and keep getting errors. Any help…
formula if then - output number of days
If Written Notice Due (Days) = 30, then Advance Notification days = 90; if 60 then 120, if 90 then 150, if 120 then 240 I will enter the data on Written Notice Due Days column (30/60/90/120) and I need a formula to output to Advance Notifications.