-
Reports-Data from single cell/row from multiple sheets
Hello, Brand new to smartsheets. When I run a report, it grabs all the data from multiple sheets and the entire column of each sheet. This makes the report have 10+ rows for each sheet, when I want one row from each specific sheet . Is there a way to define what row I want to report? I would like to be able to run a report…
-
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…
-
How to count data in children rows based on criteria in parent rows
Hello all. I am thinking this would best be done in a Sheet Summary but my brain seems to still be in winter break mode. Hoping someone can point me in the right direction. My Smartsheet is a list of courses (parent rows including course title and date) with participants (children rows including participant names and a…
-
Problem with form on Ipad
In form, user are able to take photo with IPAD directly with the form, but my users are not able to take more then 1 photo with the form. Do you have any solution for this?
-
Is it possible to set up an If statement on a “Child” field dependent on a date in the Parent field?
What I am looking to do is have a field fill in Yes or No based on the Impacted Article Complete Date in the Child row and the Alert Expiration Date in the Parent Row. If the Impacted Article complete Date is prior to the Alert Expiration Date, the field would fill in Yes. If the date is after the Alert Expiration Date, it…
-
Email Notification to an employee without a smartsheet account
I have a form that our employees will fill out in the field to request a special price. Once that has been approved i want to send an email back to that the employee confirming we have approved their request. I have them filling out their email in the form and have tried to use that in the automation to send them the email…
-
Ideas for how to automate distributing Meeting Agendas and Minutes ?
Hi, I am trying to create a meeting minutes template which both facilitates taking minutes against an agenda and also automates distribution of minutes to 'Attendees' when ready. I am using multiple rows to list Agenda topics (under a parent Meeting Title line) and then logging the minutes for each topic in a neighboring…
-
Multiple IF function pull from multiple cells
I am working on a spend tracker and i am having trouble pulling currency conversions from other cells in the row. I need the 'committed amount in USD' to pull from the correct currency conversion cell depending on the currency selected. current formula i have that works with pulling from just one cell is - =IF(Currency@row…
-
Raising Flag for at Risk Tasks
I would like the flag to be red if the date is within 7 days of "today", AND, if "Status" is not "Complete", and I want the flag to be white if the "Due Date" is blank, greater than seven days away, or if the task status is "Complete" I have: IF(ISBLANK([Due Date]9), 0, IF([Due Date]9 <= TODAY(7), 1, 0)) I just don't know…
-
Copy entries on a submitted form
We are using SmartSheet to collect and manage our team members weekly status reports. We are collecting the data via a form. Team members submit the form each week via the URL. Is it possible to have the prior week's data entries pre-populate in the form so users do not have to re-type the same information they may have…
