How to Implement Time Reporting and Assignment in SmartSheet?

Hi Everyone,

I hope you are doing well.

I have a question. I have maintained 2 sheets, one for Project Assignment to Resources and one for Resources Time Reporting.

In first sheet (Project Assignment), I assigned Projects to Resources on Weekly basis.

In the second sheet (Time Reporting for Resources), I have maintained form. In this form, I need to implement the projects, which are assigned in the first sheet (Project Assignment).

How can I Implement this?

Please do needful...

Thanks in advance....

Find more posts tagged with

Reports

Accepted answers

All comments

Julio S.

Hi @Suneel,

From what you explain it sounds like you'd like to implement a project creation system based of an initial project intake sheet where all projects are listed and assigned to resources.

If your account doesn't have Control Center to automate this process, you may want to create Project template sheet(s) that each resource can download to track their project progress.

Our Solution Center also offers some template packages that can help building this solution - "Project Management Office" is a good example of this.

If this doesn't fully relate to what you are trying to build or you'd need further advise, please make sure to include some captures of your sheets (ensuring that any confidential data has been previously hidden).

I hope that this can be of help.

Cheers!

Julio

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.