Information in a form populates specific cell.

Hello,

Just investigating an idea. I'm building a staff register sheet.

I'm curious to know if its possible to populate specific cells by the answers given in a form?

So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate that cell specifically in their column and on the date which they are on leave( or other)?

Maybe I'm making this complicated? Maybe there is a better way. Please let me know your thoughts. Thank you.

Find more posts tagged with

Accepted answers

All comments

Darla Brown

Hi,

Is your out-of-office intake sheet different from your staff register? If so, you can use an index/collect formula to update those cells based on name and date.

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.