- 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
我想旗帜是红色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
- Slow updates on Formulas and Cell Links
The last 24 hours have been a nightmare. I have been doing maintenance on some of our data sheets which have formulas and that link to roll up sheets. The cells are taking a long to to update -and in some cases haven't updated at all (i.e. I can see in the cell history when the last update "cell-link" update was and it was…
- RYG formula with a date reference
Looking for formula help with RYG referencing a date column. I want a green ball if the expiration date is more than a year away, yellow ball for expiration between today and 365 days and red for any date in the past.
- If outcome of Formula is 0 show blank
Hi All, I'm using a formula to count how many stores we have opened in a certain country/month. This information is then used in a chart in a dashboard. The problem is that when we haven't opened any store it shows a zero. This zero is also displayed in the chart, and don't want this. So is it possible to make the formula…
