-
Contacts list on webform
I would like to use the dropdown list of contacts in a web-form, does anyone know if this is possible? thanks Adam
-
Gantt View - Settings requests
Hi, I'm trying to create a dynamic 'To-Do' list (for want of a better phrase), that automatically steps the jobs - i.e. only start task 2 when task 1 is expected to complete. I want to make this as automated as possible, and I understand that dependancy columns do not accept formulas, but wanted to know if there was…
-
Gantt zoom to current day (centered) on open?
Hello, Is there a setting to set the current day to be centered in the gantt view when I open my sheet? I always have to scroll over to the current day on long projects. Thanks, Phil
-
How to select a last added value from a column
Would love to get feedback on how to get a "Last added value" of a particular item. I have a list of items which keeps adding in the sheet as new rows. I need a formula that looks at a column to pull the latest value/entry made. What I want is a formula that updates automatically as I populate new rows. Below is a…
-
Use of the system column to get the modified date
Hello everybody, I am trying to automate the input of the modification date of a particular cell on my sheet. I figured that since this information is already available in the system column [Modified] - I'd like to take that info to put it into another cell (with Date properties) Thanks in advance for the support Chris
-
Expired Date code
So i recently create a new Cell called " Expired Date" what I'm trying to do in this cell is to show when a date has been expired , based on the Promised Date, but i found that if i left mi code just like this, But =IF([Promised Date]4 > TODAY(0), "Expired date", "-" i don't have a restriction. And i try this code, but i…
-
Recurring task with task results stored per row
Good morning all I have created a grid for 'preventative maintenance' program - whereby the grid shows the task, owned by, frequency (daily/weekly/monthly etc), date last completed (user enters this each time they complete the task) and date next due is calculated (from the date last completed). But - my gap is that i also…
-
Managing Multiple Audit Sheets
I'm working on setting up a management system for process audits, which are required in various departments on either a monthly or quarterly basis. Each sheet contains several rows of audit criteria and yields a single score on the top parent row showing plant, audit, date, and score. Since there are multiple plants,…
-
Project scheduling - moving from Excel
We currently use Excel but want to move our Scheduling spreadsheet to Smartsheet. Here are some details: * We have 8 employees that can weld. * Some of the 8 can work on small parts, some can work on large parts, and some can work both. * Our Sales Orders may contain small parts, large parts or both. We list how much time…
-
SUMIFS, cross-sheet reference based on dates.
Sorry if this is a duplicate. I couldn't find an answer that fit my problem.. Formula: =SUMIFS({AccHours}, {ShipDate}, <=Date3, {completed}, <>"x") All references are from another sheet except Date3. Date3 is a formula as well, which is TODAY()+2. This works in Excel, but doesn't seem to work here. I don't get an error,…
