Trying to make a simple task management sheet, using today's date and the task status to define a Red, Yellow, Green or Grey ball.
If end date is today or later, AND status is not complete or cancelled, green
If end date is today…
Formulas and Functions11Anna Keeton
I've tried multiple searches and haven't found the right keyword/tricky phrase to answer my question.
I am using a form for submissions and trying to calculate how long a trend has been occurring. Right now my working formula is this:
Formulas and Functions31Chris Rea
I would like to set up a single call log, where I could put information into a sheet that would have a cell with a pull down that would populate with unique client names (or ID's) from a column in another sheet. So, when I put a log entry…
Using Smartsheet8Julia Johnson and Dennis Hoshield
Appreciate your help! I have a sheet, where Auto-number is taken up for the first column. I have a Priority Column, which I want to auto-populate based on if the number already exists.
Item # | Item Requested | Priority
21 | Test 1 | 1…
Formulas and Functions22dsmartsheetuser
This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but …
Formulas and Functions62scott.barrett
I'm looking to find a formula that will capture the last six months of data and then return the highest value within those six values. On excel, I've used, for example, MAX(OFFSET(B3,COUNTA(B3:B113)-6,0,6,1)) but I see "offset" i…
Formulas and Functions10Nicole Rivera
Is anyone else having issues building multiple other sheet references? It keeps backing out of the formula box when I finalize the reference. It seems to make the reference alright, but I have to type it in instead of the reference going w…
Formulas and Functions12[email protected]
I'm brand new to Smart Sheet and still learning the abundance of inner workings - hoping to find some help with what is probably an easy formula but I can't seem to get it right!
I'm trying to change the color of the RYG ball und…
Formulas and Functions55Megan Nash
I am trying to use SmartSheet to send out a form to vendors that allows them to select choices in a Multi-Select field. I then need to have the choices the vendors selected in the multi-select field split out into a binary type of indicato…
Formulas and Functions26Kyle Wefler
I am trying to use the =SUMIFS formula to sum up a range of donations that occurred on a specific date. Essentially, I have a giant list of donations, with a column that shows date, and a column that shows the donation total. I'd l…
Formulas and Functions15Gavin Frank
Hi all, I'm having a little trouble with creating the right formula for my "at risk" / "attn" column.
(Image) I only want the column to flag is the status is not complete and the target end date is past due. My current …
Formulas and Functions22Titilope Akinlose
I'm looking at how I can migrate project plans (Omniplan) into Smartsheet to then use the resource management element to see people's capacity and adjust the schedule to smooth delivery. Has anyone done something similar or have any learni…
Is it possible to create a fixed cross sheet reference such that my formulas will always pull the first row of data from the target sheet? I am building a Dashboard off of results from a Form that I have set to add new submissions a…
Formulas and Functions28Dean Arvan
I'd like to automate the calculation of a rolling average:
"Average the value of the past four weeks"
"Average the value of the past 12 weeks"
The 'SUP avg' column is what I want to average, and 'W#' is week number.
Formulas and Functions26fred sodergren
I have logged a ticket for help in merging sheet/data from a suspended account to a current account, but I haven't yet heard back since I logged it 6 days ago. Does anyone know whether it is possible to get the data/sheet?
Using Smartsheet15Rose Zhao
Hello, we have a lot of Groups with many members. I need to do an audit of each Group's members to make sure people are in the right Group (we've had some turnover/people changing teams). I am looking for a way to export to Excel each Grou…
I need to calculate the total number of points in the "Points Column" by each person in the "Name" column and I cannot figure out how its calculated. I tried to brainstorm with another co-worker and we both had troubl…
Formulas and Functions18CieraB
This one was a challenge. I thought I had it solved, but an erroneous value showed up, necessitating taking the formula back to the drawing board.
The requirement: Show me the oldest Bill of Lading number that does not have a status of &…
Formulas and Functions34JReisman27
I can trying to get my sheet to calculate different values based on what is selected in the drop down. Example: If "Partner introduction" is selected populate 10 points in "points earned" column and $1 in the "do…
Formulas and Functions16CieraB
I need to be able to roll up associated transmittal #s to 1 Transmittal and if the assessment status is Not Compliant for any of the Compliance Assessments then Transmittal 1 should equal Not Compliant, Transmittal 2 = Not Compliant, Trans…
Formulas and Functions21Jessica Larkin
I have been searching through the posts and found this formula: =IF(Complete4 = 0, TODAY(), “”) using my own column names. Each time I've tried to accept the formula, I get this error message: unparseable. Am I missing some of the formula …
I am working on creating a form for stakeholders to complete that will populate a smartsheet that we've had in place for several months. This would create efficiencies for us and help our stakeholders as well. I want to be able to do the f…
Formulas and Functions22D Gray
We have over 500 smart sheets for various processes. We'd like to know which smart sheets have had no activity for the day. Is there an way to create a report for this? Any ideas or suggestions would be highly appreciated.
Premium Apps and Integrations21Jayesh Kasim
I'm in need of performing incremental synchronization for REST API to fetch only the recent data of endpoints in general like recently added comments,rows,updated requests after a specfic time stamp,
API & Developers30Chethan k
Just have a query regarding Smartsheet forms. I am currently setting up a form to track consumables for a project. The project may have up to 20/ 30 different consumables associated with it.
Is it possible to use a multi-select d…
I'm trying to setup a formula that allows me to count actions (in red) and that also shows me the weekday in which they were made. The columns I'm using for this are 'S' and 'Action Creation Date'.
My formula is currently the fol…
Formulas and Functions21Carolina Rivera
I'm currently trying to count how many red entries (in the "Puri Safety" column) are in the month of June (using the "Created" column). I'm trying to use the following formula:
Formulas and Functions46Carolina Rivera
=DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) - WEEKDAY(TODAY()))
It is the Weekday part of the formula that is stopping it from running. Using INT and VALUE and whatever else I can think of doesn't work.
Formulas and Functions23[email protected]
I'm having trouble embedding a powerpoint file in my Dashboard. Whenever I add the link, I get an error message (photo attached).
(Image) Currently, I go into my powerpoint file, click File, and then Share -> Embed and copy/pa…
Using Smartsheet31Jean Ye
is there a possibility to display 2 logos at the sheet level?
I know that I can include a logo image to the workspace and that will replace the "smartsheet" logo from all files within that workspace. But what I am trying to d…