-
Hi there,
Okay, so here's what I'm trying to do. Our team is using a smartsheet schedule and within that schedule, is a bunch of sub-schedules, that all work together in glorious harmony :)
Up until now, I've been able to use the Predece…
Using Smartsheet183
QueenD
-
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
-
Hi,
I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value.
I know that the changed to functionality is available through…
Formulas and Functions49
Scott Rae
-
Hi,
I have a Inventory Sheet with list of items and also the quantity of each item. I also have products that use various items from the Inventory list, for example: Product #1 = 2 screws, 1 sign, and 2 hooks. And the way I have set it up …
Using Smartsheet56
Benny Neufeld
-
I have a database which is filled by clients through form. In Area column, the clients will update the area from their house where the issue is located. It is multiple selection. Screenshot attached.
(Image)
In my metrics sheet, I want to…
Formulas and Functions18
Abhiraj Joshi
-
Hello All,
We've been hunting high and low for a good task mgmt system for weeks, and Smartsheet is looking very promising. However, there doesn't seem to be any primary or foreign key type functions. How do you relate two sheets with eac…
Formulas and Functions591
SeanR
-
Hi all!
New to Smartsheet so please bear with me and my (maybe perhaps)silly question but one I haven't been able to find a solution to. I am using Smartsheet to compile online student registrations. My format: I have one "Master Shee…
Formulas and Functions20
Alex Zylka
-
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.
Situation:
I would like to have a form where someone selects one op…
Formulas and Functions2379
Dajah
-
Hi everyone, i have a group of four sheets and i want to copy specific rows to another sheet. I have a column called "FORMAL RECLAMACIÓN" and i want to copy the entire row to another sheet if there´s a date on this column.
Is thi…
Formulas and Functions11
Sebastian Avila
-
We use a standard project plan (~100 tasks/steps) as a template for our team, and it gets copied for each new project. There are ~6 tasks on the project plan that drive Jira task ticket creation. Instead of adding extra columns to the st…
Using Smartsheet25
Garo Stone-DerHagopian
-
(Image) Hello - I'm trying to add to a Dashboard. I need to see status by color for each child row. I also need a count by each child row (Admin, CPM, etc.). Help! Thank you.
Formulas and Functions20
Staci Britton
-
Hello, I hope I explain this the right way.
I want to to find if a specific (row-level) combination of employee and date that exists on the first sheet also exists on the second sheet and if so, use a formula to flag the row that has the c…
Formulas and Functions17
Sandra Wilkins
-
Is it possible to reference the latest comment on a row, in a cell?
And if we cannot currently do so, could this be considered an additional feature in the future? I would love to see the latest "update" on a project task as opp…
Using Smartsheet371
@daniel
-
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 Functions323
Robin Soprano
-
Good afternoon
We have a bid invite sheet that we fill out with prospective jobs (each row is a prospective job) to bid on. It has multiple columns of Data that if we decide to bid on the job would need to be transferred to our sales/esti…
Using Smartsheet184
BESP10
-
Hi,
I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) which needs to be tracked and ana…
Using Smartsheet38
Abhiraj Joshi
-
I am trying to show a ratio on my dashboard and would like to know if I could use a function to find the ratio.
Formulas and Functions28
Hattia Fitzgerald-Jones
-
I know that the smartsheet charts app is still in production, but is it possible to have sheet containing North American states and hyperlinks, then using the 'map' chart, click on a particular state and then it will take you to that hype…
API & Developers286
dwayne.waterman21236
-
Thanks to Paul Newcome, I was able to get a WBS schedule working. Now I need to create several schedules, using the WBS as the left two columns. Here is the problem - I need for all schedules to update whenever a row is added or deleted …
Formulas and Functions13
Trisha Martinez
-
I have a DataMesh sequence that I run that where the source sheet can have 1 to N number of entries, and it's valid. As I understand it, DataMesh only allows me to select two options - Pick First Match and Ignore Entries. In either of thos…
Premium Apps and Integrations19
Mike Rini
-
I'm trying to figure out an automatic way to run a function in a cell, and have that function paste the value, and only the value, to that cell. I don't want the formula to continue to exist within the cell. Similar to if I copied the cell…
Formulas and Functions183
@BigNate
-
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 Functions19
Julia Mazza
-
(Image) For example, for the DFM/DDFM Support Type, I would like to know that there are:
Communication:
(1) Ashley Pierce
(1) Tanner May
Proposal Review:
(1) Alexa Briggs
(2) Ashley Pierce
Formulas and Functions19
Ashley Pierce
-
Hi,
Is there to keep the previous data if the Reference if deleted.
I have this formula
=IF(vlookup(referencetoanotherSheer)=x, True). But if the other Sheet is deleted, I want it to maintain the value instead of showing #REF
Formulas and Functions13
Bhargava Ram Kummamuru
-
I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to the tabs/sheets they need. I…
Using Smartsheet29
Dennis Knipfer
-
Hi,
I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet.
EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that …
Using Smartsheet34
Benjamin Hatmaker
-
Hi,
I noticed when using Index match on auto generated numbers something weird happens. On sheet A I use Index({desired result Sheet B}, match(sheet A @row, {search Criteria Sheet B},0),1) where Sheet A @Row is an auto generated number an…
Formulas and Functions21
Amanda Berta
-
Hi All,
I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet?
Thanks
Formulas and Functions551
Jonathan Vo
-
I have a sheet that's linked into a pivot sheet via a series of sumif cross sheet formulae. This sheet is looking into the pivot sheet at a point in time e.g. month of April YTD information, and the Pivot will update monthly as new data i…
Using Smartsheet14
Jennifer Murphy
-
I'm trying to write a formula in my driver sheet that will search for an employee ID number in the completion sheet and return the text from a column within the completion sheet. I wrote the following but it returns a #NOMATCH value if th…
Formulas and Functions70
ICue
