-
Good morning/afternoon. I have been searching in the help articles and community for an answer to my question, to no avail. I have tried a few different suggestions but nothing has worked so far. Here is my dilemma. I have a sheet that…
Formulas and Functions45
Laurie Bearden
-
Hi,
(Image) I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great.
BUT....
It now red …
Formulas and Functions33
Ruth Potts
-
We are looking to geocode street addresses that are entered into Smartsheet.
Using Smartsheet11
Allie McDougall
-
I have tried this many ways and can't figure it out. The column names I am working with are: "CaseRegNum", "Type of Review", and "Status".
Each parent row is a different year and beneath each year are cases ID…
Formulas and Functions13
Paul Dieterich
-
Hello,
All of my Parent rows are expanding automatically when I have a filter on. This happens every time a member of my team refreshes the page.
Is there a way to have my filter on and keep the Parents rows from expanding automatically?
Formulas and Functions14
John Sisounthone
-
Hello - I am sending out pretty lengthly update request logic emails. I was wondering if there was a way that when the person receives an email they see only a few columns, but when they click the link to update the form, all of the column…
Formulas and Functions10
Jamie Kalff
-
I am trying to pull contract numbers from an Active Contract file over to a 2nd file using the customer name as the unique identifier which is working just fine via INDEX(MATCH), however, if a customer has more than 1 active contract it on…
Formulas and Functions14
Lexie Ozolnieks
-
Hi,
I have a large data set that I paste into Smartsheet from excel for a Dashboard to populate. When I paste some of the data in that's in 1 cell in excel Smartsheet is splitting it across multiple columns meaning I manually have to amen…
Formulas and Functions4
Maxine Roberts
-
I have a very simple workflow that is not sending email when rows are added. I have been testing with me doing the entry and I don't get emails. My notifications and Automation Permissions are correctly set.
Can anyone provide insight or …
Formulas and Functions76
Gary Norton
-
Hey Smartsheets Community!
I can't find any information on this so I'm hoping y'all can help! We are making a panel application form and we're attempting to make a form that will fill with pre-arranged dates but only allow for a single sel…
Using Smartsheet13
Nate Roylance
-
Hi all,
I hope you're well and safe!
I've developed a solution that lets you store the date or value.
You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work.
We'd trigger the copy-row to another sh…
Formulas and Functions285
Andrée Starå
-
I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/n…
Using Smartsheet63
Daniel William Maycock
-
Hello,
Is there a way for me to hide rows if one of the cells says "completed" by using a conditioning format?
If that is not possible, is there a formula that I can implement that would get the job done?
I am managing a photogra…
Formulas and Functions3
John Sisounthone
-
Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND the total % complete. We use parent rows…
Formulas and Functions11
Nikki McIntosh
-
I have a daily reports grid and everyone in my team must complete a form everyday. If by 3 on any given day they have yet to do this, I want an email reminder sent to them. Is this possible? Thanks in advance!
Using Smartsheet1
Brian Cianciolo
-
Hi,
When there is a workflow to copy a row to another sheet, why does the copied row sometimes appear down at the bottom of the sheet, leaving ~50 completely empty rows in-between the last row or text? I know technically smartsheet must b…
Using Smartsheet2
Julia C Peterson
-
The "Smartsheet Formula Examples" template, while very helpful, appears to have a variety of issues with cell references that have been moved over time. Somewhere around row 26 things start to get weird.
Is this only on my copy o…
Formulas and Functions72
Jamie Bedford
-
My objective is to return a sum of all 'Work Hours' that are in a department (Wire in this example), that fall within a date range of the 'END' date that Smartsheet is reporting..
This formula returns a value, but I've checked manually, an…
Formulas and Functions12
Larry Bejcar
-
I have a list of employee information in one smartsheet. In another smartsheet, I'm recording events/things about employees. I'd like to have a dropdown list that have the list of employees names (from the other sheet) that I could use t…
Formulas and Functions617
Robin Soprano
-
(Image) Hi there! I am working to automate the RYGG balls and its like I can get parts of the formula to work separately but not all together. I added a Past Due column to use to try to refer to that indicator to get the formula to be a li…
Formulas and Functions11
Leslye Jackson
-
Hello Community,
I’m the forms product manager at Smartsheet and am pleased to let you know that we have launched a new version of our form builder that includes conditional logic.
The new, full-screen form builder keeps more of the sett…
Announcements454
Caroline S.
-
Hello! I am attempting to create a Smartsheet form. When a user completes the form they need to identify every account that will be impacted by the project associated with that form.
How can we include a multi-select filed in the form…
Formulas and Functions12
John Crick
-
Hi,
Do we have Date and Time format now for Date columns?
Formulas and Functions43
Benjo09
-
Hi Everyone,
I am used to working in excel and using keyboard shortcuts to navigate my sheets without having to use a mouse. Is there a keyboard shortcut to delete a row? if not can how do I let the product team know to add this to the dev…
Formulas and Functions24
Cathy Cao
-
With in Dynamic View's details panel is there a way you can start to type some of the drop down information to pull up that option instead of scrolling for the right one? See below 'Market' can't type. Am I doing something wrong or is th…
Premium Apps and Integrations11
MichelleBohn
-
I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I …
Using Smartsheet42
Nicole Campbell
-
I am getting errors when attempting to invite a user to smartsheets. The error "
[email protected]" is currently a licensed user in Smartsheet. To add them to your account, grant them a license"
I do not want to grant them…
Using Smartsheet11
Charles L
-
Hi,
I'm using a template and it already allow me to flag a column when At Risk. I would like to count how many items I have flagged, but i'm not sure how.
I've used
=SUMIF({Sheet - Request Tracker with Form Range 1}, "Red")
=C…
Formulas and Functions115
Julio Martinez Coronado
-
Use case.
4 sheets Intake Sheet, Prioritization sheet, Resource sheet & Overall Status Sheet
When a project is requested it is automatically added to the "Intake" sheet through the form. Status field is New.
When we agree th…
Using Smartsheet51
Rebecca Larkin-Martinez
-
I have a status column with red, yellow and green. I'm needing a formula to change these colours when the percentage complete column gets below a certain percentage.
i.e. 1-50% Red
51%-99% Yellow
100% Green
Formulas and Functions43
Arama Eruera
