# [email protected]’s Profile

points
76

I am trying to calculate weeks out from a set date, and figured out a way, but wondering if there is an easier way without having a helper column (Days Diff column). The below columns is what I have:

Weeks Out    Day Diff    Start Date

I have 2 formulas:

In the Day Diff column I have

Hi,

Can anyone help me with a If then formula? I have been trying several things and haven't had any luck.

I need to write an IF then formula for the below:

Column A checkbox is checked when Column B contains text (any text).

Does anyone know what this formula would be?

Thank you,

Crystal

Hi,

I have a sheet within parent/child rows, and need to count the number of unique contacts within each of the children rows of each parent. I have a vendor column that has a parent row and children row (only the children rows list the vendor contacts).

I need to count the number of unique vendor

Hi,

I have a set of a set of data that I am trying to do a SUMIF formula on and am having difficulty finding the correct formula, Essentially I have 3 columns.

Project Quarter

Pyramid

Sample Size

I am trying to sumif the Sample Size column range if the criterian is met for a specific project

Hi,

Is there a way to do an If/Then formula for obtaining a count if a certain word is typed in a cell so that the count automatically adds one for each time the word is entered?

Thank you,

Hi,

I have been using the Calendar App for some time now, but noticed that team members whom have recently got the app have new features that I do not. They are able to custom color code things where my app settings still show just the example tiles and does not give any options to custom color

How can I get the =WEEKNUMBER consider a week from Monday to Sunday. I have some entries on Sundays that is showing week number of following

Hi,

I read in another tread that the ability to select multiple items in a dropdown list was in development. Does anyone know if that is available

Is it possible to get a date (mm/dd/yy) from a week number?  Ultimately I'd like to get the Friday of the week number.

Using today as an example (1/11/18), the week number is 2 and  Friday is 1/12/18.  I've tried some different Excel formulas but am not getting anything to work in Smartsheet.