-
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 Smartsheet303
John.Bruzza
-
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 Smartsheet55
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 Smartsheet177
Richard Heath
-
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 Functions1716
[email protected]
-
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 Smartsheet64
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 Smartsheet64
Shah_0614
-
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 Smartsheet835
Stevefc
-
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 Functions118
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 Functions36
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 Smartsheet499
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 Functions127
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 Functions194
ELENA LUCERO
-
https://us.v-cdn.net/6031209/uploads/989/GOFNFABBKTTA.jpg
This is an easy way to keep track of your invoices
Using Smartsheet30
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 Smartsheet100
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 Functions315
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 Functions34
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 Functions790
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 Smartsheet55
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 Smartsheet42
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 Functions64
[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 & Developers941
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 Functions49
Deena Duran
-
Hi, We are creating an automated workflow that requests an update thru a specific mail and it does not seem to work.
Automated approval workflows work perfectly but update requests don't send the appropriate mail requested (eventhough in …
Using Smartsheet75
karen.michel99046
-
Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row.
For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours…
Formulas and Functions43
dplunkett79331
-
Hi,
I'm trying to get a Percentage of Child Rows with Check Mark. Can anyone help out?
=COUNTIF(CHILDREN(), 1) + ""
returns the count of checked boxes.
=(COUNT(CHILDREN(), 0) + ""
returns the count of total rows, c…
Formulas and Functions96
craigwaco
-
Many of our team members have iPhones and the new photo format apple is pushing is .HEIC.
When we upload their photos to the attachment line they are not able to be clicked on and viewed the way a JPEG is. Seeing that this a new direction …
Using Smartsheet35
@iamhunterabrams
-
hey everyone,
i want to ask about the "approval request automation". i have project that need some approval request for the spesific people. for example, in my organization, i have 2 Divison Manager, which is a different person.
…
Using Smartsheet13
Aditya Muhammad
-
In the Control Center, I create a group of files each time a new project is started. I am being asked to create a report/sheet/dashboard that shows the date of the last time the project manager viewed/edited the sheet. If successful, this …
Premium Apps and Integrations63
M. David
-
Hello. I worked with someone on a previous discussion, but for some reason cannot locate it now. I have one data base file with the work orders from many different community locations. I wanted a solution for the Work Order Number to be a …
Formulas and Functions43
M. David
-
Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying to figure out the quickest and best sol…
Using Smartsheet33
Tucker Webb
