-
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…
-
Copying formulae on sheets where the input is through the forms function
Hi Smartsheet team, My team and I use smartsheet to track our business development opportunities. When we get new leads our team use forms to input the data they need which then adds a new line into our smartsheet doc. However some of the cells in the sheet use currency formulae which do not replicate when we add in a new…
-
Is it possible to change the layout/ style of the Gantt chart?
Hello, to present an overwiev of the projects I´m managing with Smartsheet I need a more "presentable" version of the Gantt chart. Is there any chance in Smartsheet to make the Gantt look different, for example to make some tasks thicker than others or to change the entire form of the chart? As far as I know it´s not…
-
Manual cell entry/autofill second cell by referencing another sheet
I have sheet 1 with cell A and cell B, I would like to manually enter cell B and have cell A auto populate by searching/referencing sheet 2. best, Owen
