
Hello,
Is there any formula to post(return) the name of the logged in user?
I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODA…
Formulas and Functions61
majdesber

Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over?
=LOOKUP(F2,{100,7,14,21,30,45,90,180},{"07","714","1421","2130",&quo…
Formulas and Functions5
Iris Fuentes

Status  Column Heading
Open  Drop Down
Closed  Drop Down
CIT  Drop Down
Wanting to count how many "open"
Formulas and Functions11
Mike Boyer

I have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?
Formulas and Functions10
Sonny Mendoza

I'm trying to do a countif statement that checks if a request is approved or denied, and the return to work date is great than today's date. I've tried multiple ways and can't figure it out. Any ideas?
https://us.vcdn.net/6031209/uploads/…
Formulas and Functions5
Kasey Bernard

Formula wizards! Can you help me with this one?
I have a column for Primary Team (single select) and a column for Secondary Teams (multiselect). I want to drive a report widget to include rows where a certain team, let's say "Team X…
Formulas and Functions4
Morgan Frost

I'm trying to create a formula that will return a red, yellow, or green ball. I saw the below formula on someone else's comment a while back, but wasn't able to find it today. Right now my formula is:
=IF([Late Tasks]@row > 0.75 * [T…
Formulas and Functions11
Laurie Bearden

Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows:
We manage multiple events in Smartsheet. We use forms for sign ups so all…
Formulas and Functions42
Melissa PB

Ive been trying to add multiple conditions in to calculate some values for my Sheet Summary, but I cant seem to add more than 2 conditions. Each of them work individually & with 2 conditions, but when i add the third condition it alway…
Formulas and Functions15
Avantika Murthi

Good afternoon all,
I'm trying to figure out how to apply the =EOMONTH(A1,0) from excel into a smartsheet.
Any guidance on this would be most appreciated!
Thanks!
Formulas and Functions9
amiller66941

We have a form for tracking sick time. Employee must fill out the form on first day of sick. They have to fill out the same form again when they return to work. These are both tracked in the Status column (Sick and Returning).
We a…
Formulas and Functions29
rymurph

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

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

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

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

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'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

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

Hello,
I'm building a sheet in which I'm using lots of crossreferences in the sheet summary. I plan to use it as an active metric field to display summary information from data in other sheets. I will need to copy the sheet about 30 times…
Using Smartsheet17
Rachel Peabody

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

Hi all,
I'm currently experiencing an issue when I try to DataMesh a Pivot Table to an existing spreadsheet. My Pivot Table is my Source Sheet, and I use the existing spreadsheet as my Target Sheet.
The Pivot Table is set up where each r…
Premium Apps and Integrations22
KellyAnne Brophy

I have a checkbox column "Inv 3rd Party Vendor." I am needing to index a master sheet with all of our property names, and look to see if the "inv 3rd party Vendor" box is checked in that sheet. If it is, I need it to ch…
Formulas and Functions29
steve50951

I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date column and if it is not blank and (2)the …
Formulas and Functions23
Daniel Child

I'm generating a chart by creating a metics grid for a tracking sheet. I tried using this formula and it's giving me the response, "UNPARSEABLE." This is what I used, "=VLOOKUP( {Tracking Sheet Range 2}"Q1_2020" @c…
Formulas and Functions10
Shirley Vue

This works for me using helper columns where I do count(parent) and count(children)
=IF(OR(children18 = 0, Parent18 > 0), 1, 0)
If I substitute the count(children) its #UNPARSEABLE
=IF(OR(count(children) = 0, Parent18 > 0), 1, 0)
Formulas and Functions16
Stephen Wood