-
Hey all,
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 Functions11
Anna 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 Functions31
Chris 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 Smartsheet8
Julia Johnson and Dennis Hoshield
-
Hi,
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 Functions22
dsmartsheetuser
-
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 Functions62
scott.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 Functions10
Nicole 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]
-
Hi There,
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 Functions55
Megan 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 Functions26
Kyle Wefler
-
Hello!
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 Functions15
Gavin 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 Functions22
Titilope 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…
Using Smartsheet52
SteCoxy
-
Hello,
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 Functions28
Dean 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.
I k…
Formulas and Functions26
fred 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 Smartsheet15
Rose 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…
Using Smartsheet258
micheleb
-
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 Functions18
CieraB
-
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 Functions34
JReisman27
-
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 Functions16
CieraB
-
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 Functions21
Jessica 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 …
Using Smartsheet616
Gertrude619
-
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 Functions22
D 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 Integrations21
Jayesh 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 & Developers30
Chethan k
-
Hi All,
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…
Using Smartsheet33
jg124
-
Hi all!
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 Functions21
Carolina Rivera
-
Hi all!
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:
=COUNTIFS(Created:Created, IFERRO…
Formulas and Functions46
Carolina 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.
@Genevieve P
Formulas and Functions23
[email protected]
-
Hi all,
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 Smartsheet31
Jean Ye
-
Hi,
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…
Using Smartsheet24
rcabral
