Community

Hi there - 

I am working on building a slightly better project tracker for our organization. We currently utilize calculated fields that we have to define for each new project, and sometimes the project does not have enough project rows to account for all items we are tracking. 

I need help with a

Hi,

Fairly new to smartsheet, I am looking to do the following:

If 'Drop Down A' is set to 'No', then set 'Date Column B' = 'Date Column A + 30'

If 'Drop Down A' is set to 'No', then set 'Date Column D' = 'Date Column A + 14'

If 'Drop Down A' is set to 'No', then set 'Date Column E' = 'Date Column A

If I want JIRA to automatically send a Smartsheets form used as a survey upon closing a ticket in a certain JIRA project, do I need the JIRA connector?  Or will the JIRA connector not be able to do this for me?   Any advice on how to do this is greatly

Hi,

I have created a Row Report that shows only my project milestones. I use this report to represent milestones on a Project Dashboard.

What I want to do on the Dashboard is to show only the Gantt Chart portion of the report and do not include the Grid portion. I can see there's a button to

Thought I would start my own thread regarding this since it seems very quiet around this change.

Am I the only one having no luck in using the suggested shortcut CTRL ] to indent?

I am using Windows 10, Chrome webbrowser and swedish keyboard ( ] = AltGr 9)

Ctrl AltGr 9 just types the symbol ].

I am trying to build a report that in the What? section has to contain a certain project number from the project number column but any then I want to be able to find 3 different resource from the project that are checked.  The big project is a Phase, then we have sections of the phase that contain

I am trying to set color buttons to the status of each row. Currently I am getting #UNPARSEABLE

My formula is:

=IF([Status]@row = "Complete", "Yellow", " ")IF(AND([Status]@row = "Pending", "Yellow", " ")IF(AND([Status]@row = "InProcess", "Yellow", " ")IF(AND([Status]@row = "In Progress", "Yellow", "

When a project is complete we "move the rows to another sheet" so they are off the current project sheets but information is still available. The sheet we are moving the rows to is a duplicate of the original so all columns are identical. When I move the rows they go to the bottom (or close to) of

After seeing very nice dashboard presented in Best in Class Project Management video I tried to start developing something similar for our organization. However I'm struggling with creating customized buttons (like "Home", "Portfolio Dashboard", "Departments" etc) that you can see on the top of the

Hi,

I have a formula:

=IFERROR(IF(MONTH([Sale Date]2) = MONTH(TODAY()), 1, IF(MONTH([Sale Date]2) = MONTH(TODAY()) - 1, 2)), " ")

and it worked until we have two years in one sheet. I would like to know how to add YEAR to this formula so that we can compare not only MONTH but also YEAR.