Date Fields

I have two date type questions:

Question 1

I am looking to auto populate a date field as soon as two other columns are populated. I want the date to remain fixed and not change to 'today' every time the spreadsheet if opened.

The Columns Are:

Date Part Fitted - this needs the date auto entered when:

Part Number Fitted column is populated

AND

Serial Number Fitted column is populated

The Date Part Fitted column needs to be secure and not change.

Question 2

I am looking to auto populate a date field as soon as an attachment is uploaded. This needs to be a locked field the user can not change

Find more posts tagged with

Cell linking

Comments

Paul Newcome

The only two time stamp options in smartsheet are created and last modified. Unfortunately there is no way of locking the last modified down if there are going to be other changes to the row.

Date stamps have to be done manually.

J. Craig Williams

Part of what you want can be done using a third-party tool. I prefer Zapier.

See my post here:

http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/

The Zap can also trigger on a new attachment.

In regards to locking a cell, this can not be done directly.

The row can be locked, which will prevent editors from changing anything on the row. Admin's will not be affected.

Craig

Sign in to join the conversation!

Quick Links

Trending discussions

How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…