How can I auto-populate a formula in a column that is referencing values in another sheet?

I have the formula below that is referencing the Planned Date and Exit Shop Date, but when I drag the formula through the column it doesn't update these dates as well? What I want to do is as I drag the formula down a row I also want the Planned Date and Exit Shop Date to move down a row and not remain static

Is this possible to acheive in SmartSheet?

=IF({Planned Date} >= [Column3]$1, 0, IF({Exit Shop Date} < [Column2]$1, 0, IF(AND({Planned Date} <= [Column2]$1, {Exit Shop Date} >= [Column3]$1), {hrs per week}, IF(ABS([Column3]$1 - {Exit Shop Date}) <= 7, ({Exit Shop Date} - [Column2]$1 + 1) * {hrs per week}, ([Column3]$1 - {Planned Date}) * {hrs per week}))))

Find more posts tagged with

Formulas

Automations

References

Accepted answers

All comments

prime_nathaniel

@jzarichney you may want to reconsider your approach here, it is not best practice to drag or copy formulas in SMAR, you should whenever possible try to use a column formula instead. Also make sure you name things logically / intuitively. I can't really provide much more insight without seeing your actual sample data and a description of your intended use case (rather than the description of your issue).

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.