Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over?
Formulas and Functions4Iris Fuentes
Status - Column Heading
Open - Drop Down
Closed - Drop Down
CIT - Drop Down
Wanting to count how many "open"
Formulas and Functions11Mike 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 Functions10Sonny 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?
Formulas and Functions5Kasey 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 (multi-select). I want to drive a report widget to include rows where a certain team, let's say "Team X…
Formulas and Functions4Morgan Frost
Hey everyone! I am a Product Marketing Manager at Smartsheet who helped create the Coronavirus Preparedness Template Set available on Solution Center. It’s exciting to read the feedback you’ve submitted and scroll through LinkedIn to hear …
The New Work/Life Reality162Hunter Reed
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 Functions11Laurie Bearden
I have several dashboards (of reports) that I am embedding on our corporate public website. They operate as expected on the desktop but on the iPhone, scrolling doesn't work properly inside the iFrame. The header is supposed to freez…
Using Smartsheet28Dan Snodgrass
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 Functions42Melissa P-B
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 Functions15Avantika Murthi
I have template folders in a Workspace that either gets edited or deleted by Admins. I cant make them editors because then they cannot make folders and edit other documents that they need to work with. Is there a way to make it so certain …
Using Smartsheet9Jonathan Forrester
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!
Formulas and Functions9amiller66941
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).
Formulas and Functions29rymurph
While I understand the benefits of a sheet's workflow combining multiple rows into 1 update request, if the email field for all of those rows match, is there a way to not combine and send an email per row, meaning a user may get multiple e…
Using Smartsheet7Dustin Shuman
As a single mom- and full-time employee, COVID-19 brought unique challenges to our household. I both wanted to keep my kid's education progressing while maintaining progress at work. I quickly realized we needed a schedule to maintain san…
The New Work/Life Reality70@crystalrmorey
Hey everyone! As a Product Marketing Manager here at Smartsheet I am always thinking about how we can produce content that helps you work more efficiently. Especially now, we are producing new Template Sets that will help you and your orga…
The New Work/Life Reality14Hunter Reed
I am trying to pull my data from Excel into Smartsheet and have it to have multi-select columns.
I am attaching my Word doc with the descriptions and images to explain. I cannot figure out how to get that document to post nicely in this w…
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 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
I thought based on my personal settings I can get an email notification from workflows but I do not receive one. It only comes through Smartsheet at the top right where the bell is listed. How can I get this through email?
Using Smartsheet43John Morgenthaler
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
We've been celebrating the social distancing brought on by mandatory office closures and work from home has been great! Meaningless meetings have been cancelled. Chatty Kathy hasn't been stopping by our desks with distractions four times p…
The New Work/Life Reality2602Dana Esquivel
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 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
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 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 am not receiving any notifications from smartsheet and in email even if I am making changes. Before when I made a change the smartsheet automatically send notification.
Using Smartsheet11Jeremy Espiritu
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 apologize for the length of my post, but I want to be thorough in describing what I would like to do and what I’ve already tried. I’ve also searched through help and the forums, and I either haven’t found a solution or am too hyperfocuse…
Using Smartsheet44Rob Ford