-
Sending as attachment with filters
It would be awesome to be able to send out recurring attachments in which the pdf attachment is based on a filter. For instance, if it was a construction schedule and I wanted to send out a recurring two-week outlook then I could send it based on my two-week outlook filter.
-
Opening Drop Box attachments via cell phone app
All attachments for my Smartsheet program are from my Drop Box file on my computer. Staff with access have not had issue accessing them within our network. A staff member has indicated he was unable to open a file from the job site via his cell phone. I have reviewed Drop Box Help and SS Community and have not found the…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Average of lease $ amounts in a certain region
I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has been checked and to specify a region (I do a cell reference) it doesn't seem to work. For instance, in 1 region I do not…
-
Return entire row when value is matched in another sheet
I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). What I would like is to have have any rows in the source sheet which match a specific…
-
% complete based on count of completed pieces
Hi, I'm running a project where I want to report our the % completion of a sub task based on the # of pieces completed. I'm thinking I need to create a formula as the % of completion functionality looks at duration vs. actual amount of work completed. Can someone offer guidance?
-
How to show time delays on a Gantt Chart?
We are a construction company using Smartsheet to follow the progress of the construction on site. Sometimes delays occur due to weather, power, etc.. but not all trades are affected. We need to be able to visually show to the clients (via a Gantt Chart) the reason (weather, power,etc..), the length of time (Start Date,…
-
Pen/tablet devices for writing entries into smartsheet
Has anyone used pen/notepad based devices for making entries into smartsheet? We work in site construction and maintenance projects and it would be great for supervisors to walk around, enter actions into a tasks list, or responses to a checklist in the same way they do with a paper pad and pen now. Most will still use…
-
Short Interval Schedule
I am having some troubles making something like this in Smartsheet. It shows manpower throughout a project. Any Ideas how to structure a Smartsheet that would make it easy for the eyes? Gantt chart could be nice but how would i show the change is strength based on time? Thank you.
-
Stumped with a simple formula - countif with sheet reference
I feel silly, but I'm stumped. I'm trying to do a countif with a sheet reference. I want to count how many rows in my Lease Tracker 2018 sheet have Agricultural in the Category column, but I keep getting #UNPARSEABLE. What am I doing wrong? =COUNTIF({Lease Tracker 2018 Category}:{Lease Tracker 2018…