date formulas

sgowani

i'm looking for a way to add due dates.

for example,

i need the concept review 1 to be about 12 business days after after kick off

the concept review to be about 4 business days after concept review 1

concepts to product marketing to be 2 business days after the concept review

so on and so forth.

but i'm getting all kinds of errors when i try in smart sheet. especially #unpareseable

please help!

Screen Shot 2019-02-25 at 4.06.32 PM.png

Find more posts tagged with

Comments

Nic Larsen

Right click on your primary column header and select Project Settings. Enable dependencies. This will add a Predecessors and a Duration columns. This should take care of what you are trying to accomplish. See screenshot.

Mike Wilday

Then for each row you can make it dependent on another row and add lag time however you see fit.

For more on dependencies and predecessors: https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors

sgowani

thank you so much

i'm clicking my columns but i don't see a project settings. (sorry new to mac) is there another way for me to access the settings?

Mike Wilday

You have to right click on the column header (see screenshot).

sgowani

this is what i see when i click:

i don't have the same options you're showing

Screen Shot 2019-02-26 at 11.18.17 AM.png

Mike Wilday

it looks like you clicked on the Edit Column Properties link (The one at the bottom of my screenshot). Are you the admin on the account? Did you accidentally double click? You should right-click on the header.

sgowani

i'm the admin and i probably did double click - it's a mac so there is no right click per say. i've been right, left, double clicking in the header and i still just don't see the options you see.

Andrée Starå

Hi,

To right click on a mac you either CTRL+Click or tap/click with two fingers on the mousepad. It depends on your settings.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike Wilday

Try using a two-finger click. I am on a Macbook pro. I assume you are trying to use the touchpad?

sgowani

life changing.

thank you so much, it worked!!

Andrée Starå

Great!

Happy to help!

Best,

Andrée

Mike Wilday

Looks like you got it working! Glad we could help.

Sign in to join the conversation!

Quick Links

Trending discussions

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…
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