Snippets Collections
TEXT(MONTH(DATEVALUE({!f_StartDateTimeWithTimeZoneOffset}))) & "/" &
TEXT(DAY(DATEVALUE({!f_StartDateTimeWithTimeZoneOffset}))) & "/" &
TEXT(YEAR(DATEVALUE({!f_StartDateTimeWithTimeZoneOffset}))) & " " &
IF(
    VALUE(MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 12, 2)) = 0, 
    "12:" & 
    RIGHT("00" & MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 15, 2), 2) & 
    " AM", 
    IF(
        VALUE(MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 12, 2)) < 12,
        TEXT(VALUE(MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 12, 2))) & ":" & 
        RIGHT("00" & MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 15, 2), 2) & 
        " AM",
        IF(
            VALUE(MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 12, 2)) = 12,
            "12:" & 
            RIGHT("00" & MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 15, 2), 2) & 
            " PM",
            TEXT(VALUE(MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 12, 2)) - 12) & ":" & 
            RIGHT("00" & MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 15, 2), 2) & 
            " PM"
        )
    )
)
//f_GMTOffset
24 * (DATETIMEVALUE({!$Flow.CurrentDate}) - {!Convert_Today_To_DateTime.datetimeValue})

//Convert_Today_To_DateTime is an UnofficialSF Action - ConvertDateToDatetimeFlowAction

{!dateTimeVariable} + ({!f_GMTOffset}/24)

Flow version:
HYPERLINK(LEFT($Api.Enterprise_Server_URL_610, FIND( '/services', $Api.Enterprise_Server_URL_610)) & {!$Record.AccountId}, {!$Record.Account.Name})     
     
Forula version: 
HYPERLINK(LEFT($Api.Enterprise_Server_URL_610, FIND( '/services', $Api.Enterprise_Server_URL_610)) & AccountId, Account.Name)     
* _Formula:_ (Gains from SEO - Cost of SEO) / Cost of SEO  
 * _Example:_ If increased organic search traffic generates an additional $2000 in revenue, and you spent $1000 on SEO tools and content creation, your ROI is 100%.

* _Action Steps:_
    * Track revenue attributed to organic search.
 * _Formula:_ (Time spent on social media * Hourly salary) / Number of conversions through social media 
 * _Example:_ Your social media efforts resulted in 10 new e-book sales. If you spent 20 hours on social media, with an hourly rate of $30, your social cost per conversion is $60.

 * _Action Steps:_
      * Analyze if this cost is sustainable given the value of each conversion.
      * Explore ways to streamline your social media tasks.
      * Focus on platforms that yield the best results.
* _Tools:_ Ahrefs, SEMrush, Moz, and others provide advanced position tracking. 
* _Example:_ You track keywords like "mindfulness tips," "meditation for beginners," and notice your average position improving over time. This indicates your SEO efforts are paying off.  
*  _Formula_ (Number of times a keyword appears / Total words on page) * 100 
*  _Example:_ If you want to rank for "vegan cake recipes", including that phrase a few times naturally is helpful.  Repeating it excessively becomes unnatural and hurts your chances of ranking well.

*  _Action Steps:_
      *  Focus on creating valuable, informative content first.
      *  Use keyword research tools to identify related terms and phrases (e.g., "eggless cake recipes," "dairy-free frosting").
 *  _Formula:_ (Conversions / Total Visitors) * 100
 * _Example:_  Despite good traffic, your e-book has a low conversion rate on its landing page. This could mean:
       *  Your call-to-action isn't clear or persuasive enough.
       * The landing page doesn't address visitor concerns or build enough trust.
       *  There are too many distractions or form fields on the page.

 * _Action Steps:_
       * Use strong verbs and clear language in your calls-to-action.
       * Highlight the benefits for the visitor.
       * Test different landing page designs and reduce clutter. 
* _Formula:_ (Single page visits / Total sessions) * 100
 * _Example:_ Your "best homemade pasta recipes" page has a high bounce rate. This might mean:
       *  People expect quick, simple recipes, but your content is too complex. 
       * Your images are slow to load, frustrating visitors.
       *  Internal links to related recipes are missing.

 * _Action Steps:_ 
        * Use tools like Google PageSpeed Insights to check load times. 
        * Clearly format your content with headings and short paragraphs.
        * Add internal links to keep visitors engaged on your website.
* _Formula:_ (Clicks / Impressions) * 100
 * _Example:_ You see that your blog post ranks well for "easy baking recipes," but its CTR is low. This indicates a potential problem with your title or meta description. 

 * _Action Steps:_ 
      * Experiment with power words (e.g., "Effortless," "Delicious")
      * Include numbers or a question in your title.
      * Ensure your meta description provides a clear, enticing preview of the content.
REPLACE({Name},1,FIND("~",SUBSTITUTE({Name}," ","~",LEN({Name}) - LEN(SUBSTITUTE({Name}," ","")))),"")
star

Sun Apr 13 2025 23:00:56 GMT+0000 (Coordinated Universal Time)

#salesforce #screnflow #formula
star

Sun Apr 13 2025 22:59:22 GMT+0000 (Coordinated Universal Time)

#salesforce #screnflow #formula
star

Wed Sep 18 2024 20:48:41 GMT+0000 (Coordinated Universal Time)

#apex #flow #salesforce #formula
star

Wed Feb 21 2024 14:46:58 GMT+0000 (Coordinated Universal Time)

#formula
star

Wed Feb 21 2024 14:46:33 GMT+0000 (Coordinated Universal Time)

#formula
star

Wed Feb 21 2024 14:45:39 GMT+0000 (Coordinated Universal Time)

#formula
star

Wed Feb 21 2024 14:44:09 GMT+0000 (Coordinated Universal Time)

#formula
star

Wed Feb 21 2024 14:43:21 GMT+0000 (Coordinated Universal Time)

#formula
star

Wed Feb 21 2024 14:42:31 GMT+0000 (Coordinated Universal Time)

#formula
star

Wed Feb 21 2024 14:41:06 GMT+0000 (Coordinated Universal Time)

#formula
star

Fri Nov 12 2021 19:10:11 GMT+0000 (Coordinated Universal Time)

#airtable #formula #formatting

Save snippets that work with our extensions

Available in the Chrome Web Store Get Firefox Add-on Get VS Code extension