-
Log of user access to sheets
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 will show information on 20-25 projects, so automating the solution as much as…
-
Automatic ticket numbering by location
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 combination of the community abbreviation, the year, and then the number of work…
-
How to bid Materials - Construction question needing solution:
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 solution to take a materials count for my given tasks and then fill in the info I'll…
-
How can I format a sheet or report to create a customer facing inspection signoff
Hi, I work in construction and after our project managers inspect a project in the field I'd like them to have the ability to generate an inspection form for the property owner to sign on site using a tablet. Right now they are using a sheet showing all measures that were inspected where they write down the quantity of…
-
Is it possible to generate a client sign off for an inspection in the field using a tablet?
Hi, I work in construction and after our project managers inspect a project in the field I'd like them to have the ability to generate an inspection form for the property owner to sign on site using a tablet. Right now they are using a sheet showing all measures that were inspected where they write down the quantity of…
-
Sheet exceeded the maximum recommended size
Has anyone received this error message before? What are the options for large data?
-
Alerts and Notifications
Hi everyone! New to Smartsheet and trying to figure out the automation aspect - which is what really sold us on the software. So, I have a question - is it possible to send out notifications/alerts based on specific changes within a row? For example I have two tasks - Demo1 and Demo2. I need a notification to be sent out…
-
Baseline/Actual Schedule formula help
Hello all, I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additional rows with "Actual Start" and "Actual Finish". When I enter dates into those rows, I'm looking for them…
-
Formulas =SUMIF
Hi, I need help to solve this puzzle. I'm using this sumif formula =SUMIF({Supplier Invoice register Order Number}, [PO Main Contract]10, {Supplier Invoice register value}) to sum up the total value of invoices against a particular order number. I've checked that all columns are formatted as text. See snap shot of actual…
-
INDEX MATCH to OTHER WORKSHEET
Hello, I'm evaluating the use of Forms for a "field ordering" system from an Item Master Table. Best scenario is to create a form to request multiple items via a single submission (not multiple items in a single cell = less desirable data management), and also to have a confirmation submission email sent to an email…
