I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.
I would like to have a form where someone selects one op…
Formulas and Functions2379Dajah
I'm trying to count the number of entries created in a month, based on the timestamp from the system generated Created field. I am able to do this with a helper column, where I perform the Month() function from the Created field in…
Formulas and Functions69m_dorsey
Hey All -
Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't…
Formulas and Functions19Julia Mazza
I love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the ima…
Formulas and Functions197caroline_allen37286
I am trying to implement the following formula from my excel spreadsheet into my smartsheet:
=INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes"
Formulas and Functions950LouiseM
Our Senior VP is having an issue with a sheet where she is unable to indent a row to be a child/sub-task. The strange thing is she is able to right click and indent it, but not using the keyboard shortcut.
The keys are working just fine (…
I have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time wh…
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken pla…
I'm new to using SmartSheets and first time poster here. Hoping you can help me with an elegant solve? I'm trying to create a function where a row will be highlighted when it satisfies two criterias:
1. if the date created has bee…
Formulas and Functions97yheng
Hi there, Attempting to write formula to automate RYGB symbols when task is In Progress, On Hold or Complete. I've prepared a few formulas and none seem to be accurate. If someone would take a look at below attempts and let me know what ne…
Formulas and Functions99JWattz
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…
I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true?
API & Developers361katherinehall
I'm trying to determine if rows can be included / added on card view. I have my lanes setup to view by status (ie not started, in progress, blocked, complete, etc) but would like to have rows also to separate my cards by team or possibly a…
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.
It has many application & the proof of concept exists and we use it.
We use it for an approval process (for in…
API & Developers1142JeremiahHorstick
I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce.
To track the work, I have created one sheet for the legal team to use, covering all…
When creating a project many times the comments are as much instructions, as comments. Just like this modal when creating community comments, add the ability to apply Rich Text Formatting; Bold,underline,bullets, and numbered lists. RTF fu…
I have a project that requires tracking inventory and instead of barcodes we are looking at utilizing QR codes. Does anyone know whether it is possible to use the Barcode Inventory Management template that is available in Solution Center b…
Using Smartsheet111Deanna Vandermeer
How do I format my At Risk column so the flags only appear in the "children" rows, as shown in the screenshot?
Formulas and Functions87mel_berk
I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
Formulas and Functions65KDub618
I have recurring expenses monthly and it would be cool if I could have a new entry appear every month. Is there a way to do this? Thanks!
Using Smartsheet35Bret Linford
I would like to embed a countdown for Go-Live into my project dashboard. Any idea?
Using Smartsheet414[email protected]
I have a job tracker designed to track the art components of our jobs. We would like to have a column display the next nearest due date for that row. My trouble is we may have 1-10 due dates on a given row and there are non-date columns be…
Formulas and Functions46DaveyJones13
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down?
Below is the formula in E…
Archived 2017 Posts79Michael.Baker
I am working to create an automation off of the date modified field. This is to alert users if they have not updated a row in more than 4 days. Since the date modified field is not recognized as a date field I created a copy of th…
Formulas and Functions135EPayne
See attached image
The Parent Row shows 7% complete based on the 1 item being 100% and all other items being in the future. The target % complete shows 20% which makes no sense to me.
There is a formula for Target % complete:
Formulas and Functions25LLaCosta
I have a Target % Complete column in a project plan template that essentially looks to see if you are tracking to the % complete you should be based on today's date and the start and end date of any task (or tells you that you are missing …
Formulas and Functions31LLaCosta
Hi! I'm new to the community and already raising an issue. Sorry about that! If anyone can help me with this, I'd greatly appreciate it.
I'm trying to use VLOOKUP within a Product Roadmap sheet to set the values of the feature start d…
Formulas and Functions98bscruggs
I have 2 reports sitting next to each other in a dashboard.
One shows a summary of what was due yesterday.
One shows a summary of what is due in the next 5 days.
"Due Yesterday" report is set to show anything with an End Date …
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program.
I'm hoping there's a way to automatically track inventory usage base…
Formulas and Functions195@agredling
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be cop…
Formulas and Functions48Brad Huff