エンタープライズ向けに構築

Using formulas with cells linked to other sheets

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... I am pulling numbers from separate sheets into a common sheet.

Capture data from column 1 first row to column 2 second row with formula

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... since the data for CI and CO is key in separately in different row.

Trying to create an on-call schedule with auto-calc'd dates

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... Trying to create an on-call schedule with auto-calc'd dates

Colored Dots Formula

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... 11/26/24 in Formulas and Functions

Formule

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... Those cells are filled in when we scan a location.

Checking Boxes if Date is Current Week

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... I am trying to develop a formula to check the box if the Date is today or within the last week(6 days).

How can I get an average with a data set that needs to be grouped and summed first?

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... How can I get an average with a data set that needs to be grouped and summed first?

Is there a way to timestamp using a formula?

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... Is there a way to timestamp using a formula?

Perform Count on "Year-Mon" extracted from Created Date

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... I am looking to count the number of rows for every Month in a separate sheet to see new rows added over time.

NETWORKDAY Not Working With Columns With Formula

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... When I use NETWORKDAY, it returns an invalid value and I think this is because the "Bethany's Updated Start Date" has a formula in it.

Formula that can capture duplicate in "Multi Contact List" Column, whether the contact name exist al

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... Wondering if possible to find a formula to add in a helper column to capture when a contact name is repeated or duplicate in different rows, whether the contact name alone or if it comes with other names.

How Do I link the Status Column to the % Complete Column?

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... I am looking for a formula that will allow me to update the Status Column (not Schedule Health) to update based on the % Complete (or vice-versa).

Using SUMIF Formula Help

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... I just started using Smartsheet and so far am blown away by everything!