
I am very new to Smartsheet  trying to figure this out and could use some help.
I need to have my At Risk flag marked automatically if a task is due [Complete By] within three days and the [% Complete] is not 100%.
The one I am currently …
Formulas and Functions16
Cara Sikes

Hi all,
I have 2 sheets:
1) working sheet where all tickets are logged + their status is maintained
2) calculation sheet with fields showing e.g. number of open / closed tickets and so on (calculated by formulas which refer to the working…
Formulas and Functions18
Stefan Milic

Goal: create metrics for a dashboard that automatically update when new project plans are created in the same workspace.
For example: KPI=Number of late deliveries across all projects at a client
I can create a metrics sheet and create a …
Formulas and Functions16
BHannah

Hey There,
I am hoping to find a formula that will show the g/y/r status balls "overall health" based on the percentage of green, yellow or red balls in the column. Is there a way to "average" that? For example, if we …
Formulas and Functions28
Shay Baumhauer

Hi there
I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual.
I want to count how many of t…
Formulas and Functions20
Martina Barnett

We have a sheet that holds information populated by a form. The form allows people to request the data team create a report for them. Sometimes the requests are actually looking for a report that would be regenerated every month. The in…
Formulas and Functions39
Mommaduck

Hi there  first question ever! Also  not great at using the right language so sorry if it's a bit confusing!
I am currently trying to use a formula to count if a certain condition is met in column a  and in column b  to count it. so f…
Formulas and Functions13
Acorn

Hi all
Is there an IF statement or a formula that can do the above? Rather than manually ticking the box
Thanks :)
Formulas and Functions11
Leah Mayes

Hi
I'm not sure if what I am looking for is possible, but wanted to check.
What I am looking to do is populate specific cell information from one sheet to another with select row information, when a column value is yes. Example sheet that…
Formulas and Functions12
Lauren Garvey

I have an approval flow that can go to one of three contacts (sometimes two). I want to add a Final Status column to make it easier to count in a summary sheet and eventual put it on a dashboard. I'm trying to create a formula with the f…
Formulas and Functions12
Robert Francher

I'm currently trying to calculate the fuel consumption for each truck by date by using using an Index Match formula as shown below
=INDEX(Odometer:Odometer, MATCH(MAX(COLLECT(Created:Created, Created:Created, @cell <
[email protected], Truck:…
Formulas and Functions22
Rainier Hollands

Hi,
I am trying to make certain cells accessible for 2 way sharing. Is there a function like celllinking that is available 2ways? There is some financial data but mostly personnel/task and resources.
Thank you,
Esperanza
Formulas and Functions12
Esperanza Zagal

Hello,
I have my sheets set up right now to automatically send out an email with an attachment when a box is checked. I have received complaints that the emails look to formal and or spam like. Especially when the sender is "Your n…
Formulas and Functions14
Amanda Ericksen

Have found this formula in previous discussions but is unparseable.
I have gone through it a couple of times and think it is down to wrongly set parentheses, or?
Slutdato=enddate, Startdato=start date. Looking to flag (double booking) if s…
Formulas and Functions28
HOFF

I'm essentially trying to have one cell populate with text values from multiple different cells based on a certain criteria.
What I really wish I had is a JOINIF function, if that explains my problem better.
Thanks in advance!
Formulas and Functions276
gregoc43

Hi,
I'm working with two Smartsheets.
(1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the AutoNumber/System Feature (under Edit Column Properties). This features stamps new row entries wit…
Formulas and Functions32
Amy Arnold

I have about 2500 date values, imported from an Excel spreadsheet, in the YYYYMMDD numerical format. I would like to convert them to Smartsheet date values.
Any suggestions?
Formulas and Functions16
Anirudh

I am attempting to create formulas to return the next milestone date and next milestone description from a project schedule. Here is what I have currently:
https://us.vcdn.net/6031209/uploads/413/NNXTNAMADMEG.png
As you can see, the next …
Formulas and Functions67
coryg

I'm looking to count how many times "blank" occurs in the status column per date. Entries are made daily and some days have multiple entries. I would like to set up a way to get a count of number of entries per day.
Formulas and Functions13
rymurph

I am trying to set a data mesh config of data coming for a published report (which I do not have access to the source sheet), ans it seems that he config is not able to read the common values. Could it be because the source sheet is not sh…
Formulas and Functions37
Maria Fernanda Lollato

Having an entire dialog for text and number formats would make much more sense to me.. combine the currency, percentage, thousands and decimal places into it's own dialog box.
We really NEED a way to save and modify the formatting of comm…
Formulas and Functions147
Ezra

I have a sheet with a cell in each row that contains a list of comma separated values. I want to evaluate this list against a a different sheet (sheet 2) and return true if the cell contents matches one of the columns of values in sheet 2.…
Formulas and Functions12
Miriana Dounis

Trying to use COUNTIF to count how many times the values listed in Name Helper are listed in that column.
IE see screenshot below.
Id like a formula to automatically display the number 1 in the Column called "How Many Active Episodes…
Formulas and Functions20
KMan1190

I am trying to get the following to happen, and i am newer to smartsheet so need some help please.
I need that if the checkbox in 'row 2' (and under based the amount of entries) is checked AND the Lessons Complete in the first row is starr…
Formulas and Functions15
Katie Mueller

Hi all,
I'm pretty new to smartsheet, so thanking you in advance for any assistance you can provide.
I'm looking for a formula that will send out a reminder if an update request has not been received after 7 days. Here's the scenario.
I ha…
Formulas and Functions13
Barb Celic

Hi,
Please can you assist with a formula for the attached image. So if the induction column has "Yes" and Presentation column has "Yes" then the complete column should state "Yes". I'd like this formula to be…
Formulas and Functions10
sahilhq

Hi,
I'd like assistance in creating a vlook up formula. So I would like the sheet to vlook up and find the date of birth and postcode from a different sheet when the name matches. See attached image of how the sheet where the vlook up nee…
Formulas and Functions9
sahilhq

I am trying to create buckets of product golive dates using the Nested IF formula. When I only had 4 buckets, it worked perfectly. When I added 3 more buckets, I cannot get it to work. Here's the formula:
=IF([Workdays to GoLive Targe…
Formulas and Functions61
Jennifer Tillman

https://us.vcdn.net/6031209/uploads/031/I7CRYLLA49U6.png
I am trying to setup a formula, so if there is a duplicate in the Family ID column, the box becomes checked in the Duplicate column. So far, during the searching I have done for o…
Formulas and Functions18
Rebecca Lane

I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet.
I want to create a new Smartsheet that links dat…
Formulas and Functions8
Donna T