Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

Date Selection from three options

I'm tracking book publications and each of the titles in my database will have several dates for different formats - Hardback, paperback, ebook and Audio...I'm trying to create a formula that will automatically select the earliest of these dates so t...

  • 79 Views
  • 1 replies
  • 0 kudos

Resolved! IF Formulas Help

Hello. I'm trying to create an IF formula that returns some text if the date field is a specific date. Each date would need its own specific text.e.g. If my date field was 05/01/2025, then the IF formula field would return specfic text (e.g Day 1).Th...

  • 126 Views
  • 2 replies
  • 0 kudos

Resolved! Combining Dates from Multiple Fields

We're a publishing company and we keep track of content that we publish over the course of the year with these different columns showing publish dates. I'd like to do 2 things:Create 1 column that combines the dates (combining them so that they remai...

  • 274 Views
  • 5 replies
  • 0 kudos

Tracking Annual Fees and Sending Reminder emails

Hello everyone,Newbie here! I'm trying to create a base that can track all the annual membership payments and also send them an automatic email 2 weeks before the renewal date (based on the MEMBERSHIP JOINING DATE) is due, plus two more reminder emai...

  • 124 Views
  • 1 replies
  • 0 kudos

Revenue Formula Rounding Randomly

Revenue = Quantity * Price7496.90 = 150 * 49.98Why is the number rounding up to 7497.00????Another Example: $205.80 = 25 * $8.23The value I get in my Revenue Cell is rounded down to $205.75.Here is the revenue formula vs. what it should be. The numbe...

sibbotso_0-1732559442557.png sibbotso_0-1732562854558.png
  • 260 Views
  • 4 replies
  • 0 kudos

Resolved! Please help! IF formula with negative numbers

I'm trying to score based on a percentage another field is calculating.If Profitability is greater than 0%, score 2.If Profitability is between -5% and 0%, score 1.If Profitability is less than -5%, score 0.I can get it to work for greater than 0% an...

  • 194 Views
  • 3 replies
  • 0 kudos

Automatically Selecting Multiple Selections in a New Cell

We are a publishing company and we publish individual pieces of content on multiple dates.  I have a different sheet that I'd like to have all of those dates be put together into 1 cell (see attached). Is there a way to do that so that if I fill in a...

  • 287 Views
  • 5 replies
  • 0 kudos

Formula field for a created time field

Hi I have two fields ie a created time field and a formula field for the time field. I have an issue with time displayed in the formula field. It seems to convert the time I don't know why,, here is the formula: IF( {Posting Date} > NOW(), "Posted: T...

  • 129 Views
  • 1 replies
  • 0 kudos