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

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).

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 have a tricky formula I'm trying to calculate, but with no success so far...

Nested IF , logical operator (AND)

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 build a formula with IF, AND conditions but i am unsuccessful, can any one help me to sort out this please.

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.

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

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!

Formula that will automatically add $25 to the cell

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 ... Formula that will automatically add $25 to the cell

Split text into columns

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'd like to split text into separate columns.

MAXIFs Alternative?

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 have a google form that updates the prices of materials.

Having Trouble with SUMIFS

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/16/18 edited 12/09/19 in Formulas and Functions

TODAY() Function is Replacing Previous 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 have a column in a production spreadsheet that I am utilizing to enter the date of which one of our production members completes an order.

% complete based on count of completed pieces

Formulas and Functions ... 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

Building sheets that talk to each other

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 have two sheets I would like to reference data to and from and I understand how to us the =VLookup option BUT what I cant seem to get it to work.

Completed Row Drops To Bottom

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 ... Hi everyone,

フィルター