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 Functions16Cara Sikes
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 Functions18Stefan 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 Functions16BHannah
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 Functions28Shay Baumhauer
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 Functions20Martina 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 Functions39Mommaduck
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 Functions13Acorn
Is there an IF statement or a formula that can do the above? Rather than manually ticking the box
Formulas and Functions11Leah Mayes
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 Functions12Lauren 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 Functions12Robert 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]
Formulas and Functions22Rainier Hollands
I am trying to make certain cells accessible for 2 way sharing. Is there a function like cell-linking that is available 2-ways? There is some financial data but mostly personnel/task and resources.
Formulas and Functions12Esperanza Zagal
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 Functions14Amanda 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 Functions28HOFF
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 Functions276gregoc43
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 Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries wit…
Formulas and Functions32Amy 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.
Formulas and Functions16Anirudh
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:
As you can see, the next …
Formulas and Functions67coryg
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 Functions13rymurph
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 Functions37Maria 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 Functions147Ezra
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 Functions12Miriana 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 Functions20KMan1190
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 Functions15Katie Mueller
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.
Formulas and Functions13Barb Celic
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 Functions10sahilhq
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 Functions9sahilhq
I am trying to create buckets of product go-live 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 Go-Live Targe…
Formulas and Functions61Jennifer Tillman
I am trying to set-up 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 Functions18Rebecca 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 Functions8Donna T