-
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
-
Hello,
I have a sheet where I am tracking construction progress. There are a lot of data/calculations that my field personnel do not need. I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.) Each…
Using Smartsheet417
John.Bruzza
-
Hi All
I'm keen to look into options to report on project progress against schedule.
Generally we set a project programme, then progressively update %Complete against lines and the project progresses.
The progress bar works well as visu…
Formulas and Functions212
Chris_Bick
-
Hi all
I am trying to automatically add a 6 month review date to a start date, it is working fine until a start date is past June, to which I get a #invalid value error. The formula I am using is:
=DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))
…
Formulas and Functions336
IssyA
-
Hi,
My company has been using Smartsheet for the better part of 3 years now. Some staffers have had training but nothing too extensive. My company recently merged both the Communications and Marketing departments and I have been tasked wi…
API & Developers19
Travis Pryor
-
I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change c…
Using Smartsheet1074
Stevefc
-
I am trying to create a form where every student is scored under the same category all at once. For instance, I have 15 students; all 15 students will be scored on 12 categories each day, with a possible score of 1-5 for each student on ea…
Using Smartsheet30
Reed Vial
-
Hey
Is it possible to have the the drop-down list of a column changed based on the value of another column?
Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is se…
Formulas and Functions2086
[email protected]
-
Hi, Is there any way of doing a cash flow forecast/projection within Smartsheet. With most other project management software this is a built in feature. I would like to do a forecast of the monthly projected cost for the project.
Formulas and Functions42
Warren Labuschagne
-
I am attempting to create a bar chart widget that summaries hours by department on a given project, but I can't seem to figure out how to get it to display the information I need it to.
I have the data set up in a sheet as follows:
(Image)…
Formulas and Functions27
Koby, Laura
-
I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics.
*The drop downs show their total …
Using Smartsheet395
NicoN
-
Hi,
Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email.
Lauren
Using Smartsheet67
Improve Consulting
-
Our PM's are experiencing a few issues with the Gantt Chart, and I hoping someone can help.
In some instances, per the attached, the overall status suggests that the program is ahead of schedule. This is despite Sub-child 2a being on targ…
Using Smartsheet225
Richard Heath
-
Thought I would start my own thread regarding this since it seems very quiet around this change.
Am I the only one having no luck in using the suggested shortcut CTRL ] to indent?
I am using Windows 10, Chrome webbrowser and swedish keyb…
Using Smartsheet72
Mattias
-
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…
Using Smartsheet76
Shah_0614
-
I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1.
I've tried a couple of times and non of my rows are copied.
To test it, I added to the same automatio…
Formulas and Functions176
Stelina Todorova
-
Has anyone used Smartsheet hand in hand with Procore?
Background: My company is the design team on a construction project. We are using Smartsheet to handle workflows and documents questions from our subcontractor. The subcontractor is …
Formulas and Functions45
Rachel Fogleman
-
Hello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them…
Using Smartsheet617
Jef Forward
-
Hi-
I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week.
I am easily able to plot cost for items that begin or end in a calendar month, but not…
Formulas and Functions166
Mike Liggett
-
Hello, could you help me find a formula that counts all except "x".
I have a Column that has data such as: dates, "ok" and "N/A". I try using the Countif formula but cant seem to figure how to have it count a…
Formulas and Functions262
ELENA LUCERO
-
(Image) This is an easy way to keep track of your invoices
Using Smartsheet38
Thai La
-
We use a sheet as both a schedule and data collection tool as part of a much larger system we just put in place (literally 5 days ago, moved from google sheets). The information is organized manually first by employee and second by the pri…
Using Smartsheet120
OrbitalPorcupus
-
Where do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much.
Formulas and Functions389
Ryan Coles
-
Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over?
=LOOKUP(F2,{-100,7,14,21,30,45,90,180},{"0-7","7-14","14-21","21-30",&quo…
Formulas and Functions44
Iris Fuentes
-
Hi All,
I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula:
=COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, &qu…
Formulas and Functions1088
RySols
-
Hi All,
I have Word documents I am attaching to a smartsheet, that I would like a team member in the field who uses an Ipad, to be able to edit easily and save back to Smartsheet. Without too many steps involved.
PDF is also an option.
…
Using Smartsheet60
michon71241
-
Hello,
We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs.
The dashboards are updated automatically with every changes in the master project and pro…
Using Smartsheet45
Cyril_H
-
Hey
Please see attachment.
I need help with counting the number of cells in a column, (see attachment: Column [Response Sufficient?]) that contains an exclamation mark(hold) or is blank.
I basically want to count the amount of RFIs with…
Formulas and Functions72
[email protected]
-
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 & Developers1142
JeremiahHorstick
-
Hello,
I am looking at creating a way to track monthly time sheets. Ideally, I would like to have parent rows for each month with numbered days beneath. In theory, I would like to have an option where the supervisor approves that month,…
Formulas and Functions56
Deena Duran
