https://community.smartsheet.com/discussion/146964/formula-to-create-a-list-from-another-sheet-column2026-06-04T16:38:52+00:00 https://community.smartsheet.com/discussion/146697/sheet-formulas-not-updating-from-data-shuttle-file2026-06-04T16:15:25+00:00 https://community.smartsheet.com/discussion/146928/using-if-and-or-formula-to-pull-data-from-2-different-sheets-into-multiple-cells2026-06-04T13:36:57+00:00 https://community.smartsheet.com/discussion/94481/is-it-possible-to-get-copies-of-emails-sent-out-via-automation-to-a-contact-in-a-cell2026-06-04T08:57:51+00:00 https://community.smartsheet.com/discussion/146978/counting-occurrences-of-drop-down-menu-selections2026-06-04T07:06:32+00:00 https://community.smartsheet.com/discussion/146969/automated-notifications2026-06-03T20:15:35+00:00 https://community.smartsheet.com/discussion/146850/connecting-two-smartsheets-one-a-set-list-of-assets-the-other-freeform2026-06-03T19:39:46+00:00 https://community.smartsheet.com/discussion/146960/marking-successors-status-as-ready-when-the-predecessors-status-is-changed-to-complete2026-06-03T17:30:24+00:00 https://community.smartsheet.com/discussion/146962/certain-sheet-filters-no-longer-working-in-smartsheet-app2026-06-03T14:53:42+00:00 https://community.smartsheet.com/discussion/146945/changing-sheet-name-doesnt-change-sheet-name-referenced-in-formulas2026-06-02T21:44:50+00:00 https://community.smartsheet.com/discussion/146830/i-broke-my-formula2026-06-02T16:48:59+00:00 https://community.smartsheet.com/discussion/146869/based-on-value-in-column-a-do-a-lookup-to-a-different-sheet2026-06-02T13:26:51+00:00 https://community.smartsheet.com/discussion/146931/conditional-formatting-based-on-forms2026-06-02T13:13:47+00:00 https://community.smartsheet.com/discussion/146821/can-weblinks-or-hyperlinks-be-added-to-dynamic-view-or-automation-messages2026-06-02T12:23:57+00:00 https://community.smartsheet.com/discussion/146929/conditional-formatting-comparing-two-date-fields2026-06-01T21:40:27+00:00 https://community.smartsheet.com/discussion/146925/status-change-within-a-cell-formula-where-it-moves-it-to-the-next-stage-if-true2026-06-01T19:20:30+00:00 https://community.smartsheet.com/discussion/145744/automation-change-cell-value-not-working-but-working-when-test-run2026-06-01T18:22:15+00:00 https://community.smartsheet.com/discussion/146912/automation-not-triggering-emails2026-06-01T16:16:20+00:00 https://community.smartsheet.com/discussion/146602/month-end-checklist-notifications2026-06-01T15:24:17+00:00 https://community.smartsheet.com/discussion/146914/automation-won-t-stamp-last-changed-date-when-status-is-formula-linked-cells2026-06-01T15:43:24+00:00 https://community.smartsheet.com/discussion/146907/capturing-po-submission-date-time-automatically-when-status-changes-to-completed2026-06-01T12:19:53+00:00 https://community.smartsheet.com/discussion/146901/combing-3-sheets-to-get-usable-data2026-06-01T09:17:45+00:00 https://community.smartsheet.com/discussion/146894/cross-sheet-references2026-05-30T04:25:23+00:00 https://community.smartsheet.com/discussion/146898/averageifs-or-average-collect-help2026-05-29T17:59:14+00:00 https://community.smartsheet.com/discussion/146856/complete-column-appears-broken2026-05-29T14:21:27+00:00 https://community.smartsheet.com/discussion/146872/copy-rows-to-other-sheet-as-values-only2026-05-29T08:34:50+00:00 https://community.smartsheet.com/discussion/146817/multi-selection-form-into-single-rows2026-05-28T21:40:27+00:00 https://community.smartsheet.com/discussion/146866/how-to-edit-a-formula-to-pull-data-within-a-specific-date-range2026-05-28T19:43:34+00:00 https://community.smartsheet.com/discussion/146823/my-fx-is-not-working2026-05-28T12:41:50+00:00 https://community.smartsheet.com/discussion/146778/assistance-needed-with-the-following-formula2026-05-28T12:36:13+00:00 https://community.smartsheet.com/discussion/93946/new-your-survival-guide-to-formulas-is-here-meet-the-formula-handbook2026-05-28T07:52:39+00:00 https://community.smartsheet.com/discussion/146835/duplicating-a-report-sheet-in-smartsheet2026-05-27T19:06:40+00:00 https://community.smartsheet.com/discussion/146800/report-for-due-dates2026-05-27T19:04:30+00:00 https://community.smartsheet.com/discussion/146814/sheet-summary-formula2026-05-27T15:08:02+00:00 https://community.smartsheet.com/discussion/146777/automatic-updates-from-one-sheet-to-the-other-based-on-a-contact-list-in-a-column2026-05-27T13:39:27+00:00 https://community.smartsheet.com/discussion/146781/start-date-formulas-not-appearing-in-reports2026-05-27T11:36:05+00:00 https://community.smartsheet.com/discussion/146808/countif-for-days-elapsed-between-two-dates2026-05-26T22:34:01+00:00 https://community.smartsheet.com/discussion/146787/how-to-show-each-child-row-item-on-a-separate-line-in-a-generated-pdf2026-05-26T18:49:39+00:00 https://community.smartsheet.com/discussion/146803/finding-the-difference-between-completed-at-row-and-the-previous-submission2026-05-26T18:43:20+00:00 https://community.smartsheet.com/discussion/146793/formula-to-insert-date-and-or-time2026-05-26T16:03:20+00:00 https://community.smartsheet.com/discussion/146784/combine-contact-lists2026-05-26T15:01:47+00:00 https://community.smartsheet.com/discussion/146788/how-to-set-up-a-rule-depending-on-what-is-selected-in-a-previous-column2026-05-25T13:19:10+00:00 https://community.smartsheet.com/discussion/146774/trying-to-pull-most-recent-information-from-another-sheet2026-05-22T17:41:22+00:00 https://community.smartsheet.com/discussion/146740/countifs-count-the-number-of-dates-that-fall-within-one-month2026-05-22T15:15:38+00:00 https://community.smartsheet.com/discussion/146673/working-with-multiple-due-done-dates2026-05-22T15:15:01+00:00 https://community.smartsheet.com/discussion/146767/formula-result-is-n-a-automation-does-not-seem-to-evaluate-it-properly2026-05-22T13:53:44+00:00 https://community.smartsheet.com/discussion/146754/max-formula-cells-updating-in-reports2026-05-21T11:46:23+00:00 https://community.smartsheet.com/discussion/146733/cross-sheet-formula-help2026-05-20T21:31:42+00:00 https://community.smartsheet.com/discussion/145167/tracking-a-1-day-project-based-on-time-not-date2026-05-20T18:06:45+00:00 https://community.smartsheet.com/discussion/102925/invalid-view-dynamic-view-error2026-05-20T13:33:02+00:00 https://community.smartsheet.com/discussion/146713/issue-with-email-notifications-via-workflow-automation2026-05-20T12:41:15+00:00 https://community.smartsheet.com/discussion/146728/how-to-pull-the-title-from-a-hierarchy-at-ancestor-level-02026-05-20T11:59:15+00:00 https://community.smartsheet.com/discussion/146694/form-adding-rows-to-smartsheet2026-05-20T11:56:58+00:00 https://community.smartsheet.com/discussion/90530/is-there-a-smartsheet-template-for-earned-value-management-or-analysis2026-05-20T09:38:30+00:00 https://community.smartsheet.com/discussion/146714/need-to-compare-reports2026-05-19T20:15:15+00:00 https://community.smartsheet.com/discussion/146716/formula-generating-1-for-days-since-last-update2026-05-19T19:29:57+00:00 https://community.smartsheet.com/discussion/146570/gantt-view-earliest-start-date2026-05-19T15:09:55+00:00 https://community.smartsheet.com/discussion/115897/pmo-template-deleted-header-row2026-05-19T14:49:08+00:00 https://community.smartsheet.com/discussion/146701/adding-months-to-the-same-column2026-05-19T13:28:27+00:00 https://community.smartsheet.com/discussion/131338/control-center-error-message2026-05-19T12:28:06+00:00 https://community.smartsheet.com/discussion/136695/how-can-i-send-an-attachment-from-a-line-with-an-automation-workflow-to-a-recipient2026-05-18T20:01:12+00:00 https://community.smartsheet.com/discussion/146680/index-match-returning-no-match2026-05-18T14:22:01+00:00 https://community.smartsheet.com/discussion/146642/countif-cells-within-a-range-are-not-blank2026-05-18T11:59:37+00:00 https://community.smartsheet.com/discussion/146682/help-with-cross-sheet-date-value-not-being-treated-as-a-date2026-05-18T11:46:47+00:00 https://community.smartsheet.com/discussion/146670/additional-criteria-changes-result2026-05-15T15:24:25+00:00 https://community.smartsheet.com/discussion/146627/critical-path2026-05-15T07:37:49+00:00 https://community.smartsheet.com/discussion/146644/need-help-with-a-formula-to-determine-if-all-responses-have-been-received-for-each-group-in-the-smartsheet2026-05-15T01:17:55+00:00 https://community.smartsheet.com/discussion/146647/how-to-use-if-blank-with-this-formula2026-05-15T00:36:58+00:00 https://community.smartsheet.com/discussion/146630/recording-multiple-instances-of-a-project-on-off-track2026-05-14T18:58:59+00:00 https://community.smartsheet.com/discussion/146662/display-attachment-names-in-a-column2026-05-14T17:27:42+00:00 https://community.smartsheet.com/discussion/146659/checkbox-if-a-multi-selection-drop-down-is-used2026-05-14T14:43:30+00:00 https://community.smartsheet.com/discussion/53266/count-days-from-start-date-enetered-and-stop-count-when-finish-date-is-entered2026-05-13T21:07:46+00:00 https://community.smartsheet.com/discussion/146629/index-collect-cant-get-the-syntax-correct2026-05-13T19:48:07+00:00 https://community.smartsheet.com/discussion/146619/formula-to-bring-in-a-free-text-column2026-05-13T15:04:18+00:00 https://community.smartsheet.com/discussion/146609/expense-columns-are-not-syncing2026-05-13T11:46:15+00:00 https://community.smartsheet.com/discussion/146622/smartsheet-back-up2026-05-13T07:02:08+00:00 https://community.smartsheet.com/discussion/146600/date-expected2026-05-12T19:25:06+00:00 https://community.smartsheet.com/discussion/146617/detect-duplicate-form-entries2026-05-12T18:44:28+00:00 https://community.smartsheet.com/discussion/146595/referencing-another-smartsheet-when-no-match-is-found2026-05-12T17:50:09+00:00 https://community.smartsheet.com/discussion/146580/checkboxes-not-showing-after-mobile-update2026-05-12T12:34:54+00:00 https://community.smartsheet.com/discussion/146608/trying-to-build-a-helper-column-to-identify-duplicate-values-but-the-cell-value-returns-no-match2026-05-12T11:57:33+00:00 https://community.smartsheet.com/discussion/146596/index-collect-contains2026-05-11T18:20:19+00:00 https://community.smartsheet.com/discussion/146578/issue-with-future-dates-and-global-time-zones2026-05-11T12:51:10+00:00 https://community.smartsheet.com/discussion/146583/date-and-time2026-05-11T11:51:09+00:00 https://community.smartsheet.com/discussion/146587/not-getting-confirmation-mail-from-form-smartsheet2026-05-11T11:37:01+00:00 https://community.smartsheet.com/discussion/146572/does-the-cell-history-come-over-when-a-row-is-moved-from-one-sheet-to-another2026-05-08T18:36:50+00:00 https://community.smartsheet.com/discussion/146422/abnormal-display-of-hyperlink-content-in-notification-emails2026-05-08T09:00:57+00:00 https://community.smartsheet.com/discussion/111048/is-the-a-formulas-that-counts-cells-sheet-limit-question2026-05-07T17:12:37+00:00 https://community.smartsheet.com/discussion/146537/multi-select-column-not-appear-in-report-grouping2026-05-07T17:11:38+00:00 https://community.smartsheet.com/discussion/146545/count-the-number-of-unique-dates-in-the-created-date-column2026-05-07T16:18:23+00:00 https://community.smartsheet.com/discussion/146544/data-entered-on-a-report-doesnt-trigger-vlookup-based-on-the-underlying-sheet-cell-contents-why2026-05-07T16:12:50+00:00 https://community.smartsheet.com/discussion/146523/why-is-my-level-code-formula-erroring-on-just-level-22026-05-07T16:12:08+00:00 https://community.smartsheet.com/discussion/146555/absentee-calendar-log2026-05-07T15:23:34+00:00 https://community.smartsheet.com/discussion/146531/issue-with-simple-countif-formula2026-05-07T14:00:51+00:00 https://community.smartsheet.com/discussion/146552/how-to-get-attachment-to-work-on-automation2026-05-07T13:46:19+00:00 https://community.smartsheet.com/discussion/146543/join-collect-or-has-issue2026-05-07T13:32:13+00:00 https://community.smartsheet.com/discussion/146546/automation-not-working2026-05-07T11:57:03+00:00 https://community.smartsheet.com/discussion/146416/formula-that-looks-at-multiple-sheets2026-05-06T22:32:40+00:00 https://community.smartsheet.com/discussion/146488/not-receiving-emails-when-manually-pushing-an-automation-from-a-sheet2026-05-06T18:06:28+00:00 https://community.smartsheet.com/discussion/146538/join-collect-no-match2026-05-06T15:56:36+00:00 https://community.smartsheet.com/discussion/146529/counting-multiple-cell-options-in-one-formula2026-05-06T14:10:06+00:00 https://community.smartsheet.com/discussion/146519/can-i-do-a-stacked-bar-chart-of-status-types-by-week2026-05-06T12:59:15+00:00 https://community.smartsheet.com/discussion/146521/how-can-i-stop-my-number-field-from-rounding-to-the-tenth-place-decimal2026-05-06T06:04:56+00:00 https://community.smartsheet.com/discussion/133091/iferror-with-index-match-from-3-sheets2026-05-05T15:30:43+00:00 https://community.smartsheet.com/discussion/146483/index-match-and-or-function2026-05-05T15:30:29+00:00 https://community.smartsheet.com/discussion/146376/logic-help2026-05-05T13:57:25+00:00 https://community.smartsheet.com/discussion/146480/cross-reference-cell-links-from-my-sheet-to-reporting-missing-data2026-05-05T13:57:10+00:00 https://community.smartsheet.com/discussion/146495/sumifs-pulling-data-from-another-sheet-and-applying-criteria-of-a-date-range2026-05-05T04:50:07+00:00 https://community.smartsheet.com/discussion/118213/copy-paste-retaining-formulas-with-multiple-sheet-summary-field-references2026-05-05T02:23:34+00:00 https://community.smartsheet.com/discussion/146486/merging-data2026-05-04T20:14:31+00:00 https://community.smartsheet.com/discussion/146479/how-to-exclude-second-and-fourth-saturdays-in-tat-column2026-05-04T11:31:08+00:00 https://community.smartsheet.com/discussion/146464/how-to-show-parent-and-child-rows-with-filter-on2026-05-03T10:18:40+00:00 https://community.smartsheet.com/discussion/146411/creating-project-planning-sheets-from-a-template-linking-to-master-sheet2026-05-02T01:10:44+00:00 https://community.smartsheet.com/discussion/146460/sumifs-formula-bringing-back-total-of-all-items-not-items-in-specified-date-range2026-05-01T15:53:07+00:00 https://community.smartsheet.com/discussion/146340/conditional-automatic-dating2026-04-30T18:45:11+00:00 https://community.smartsheet.com/discussion/146413/column-formula2026-04-30T16:35:56+00:00 https://community.smartsheet.com/discussion/146404/complete-column-automation-populating-100-text-instead-of-100-after-recent-update2026-04-30T14:27:04+00:00 https://community.smartsheet.com/discussion/146428/using-a-checkbox-in-formula2026-04-30T12:40:43+00:00 https://community.smartsheet.com/discussion/139566/number-in-english2026-04-30T12:26:44+00:00 https://community.smartsheet.com/discussion/146423/update-assigned-person-only-for-active-phases2026-04-30T07:11:13+00:00 https://community.smartsheet.com/discussion/145872/counting-number-of-items-from-a-specific-month-with-multiple-criteria2026-04-29T15:47:59+00:00 https://community.smartsheet.com/discussion/146356/filter-on-by-default-publish-to-dashboard2026-04-29T14:06:51+00:00 https://community.smartsheet.com/discussion/145620/total-sum-not-calculating-in-smartsheet-correctly2026-04-29T12:00:36+00:00 https://community.smartsheet.com/discussion/146395/expiration-date-automation2026-04-29T11:57:11+00:00 https://community.smartsheet.com/discussion/146406/how-to-connect-data-from-project-metrics-to-portfolio-summary2026-04-29T01:12:51+00:00 https://community.smartsheet.com/discussion/146277/how-to-create-a-unique-number-via-formula-or-how-to-autonumber-via-formula-due-to-existing-autonumber-type-column2026-04-28T17:55:21+00:00 https://community.smartsheet.com/discussion/146394/average-days-in-a-status-oldest-status-date2026-04-28T17:26:49+00:00 https://community.smartsheet.com/discussion/146386/created-time2026-04-28T16:36:39+00:00 https://community.smartsheet.com/discussion/146381/annual-recurring-tasks2026-04-27T21:50:05+00:00 https://community.smartsheet.com/discussion/146380/newbie-question-need-new-sheet-column-to-reflect-what-is-on-another-sheet2026-04-27T19:51:02+00:00 https://community.smartsheet.com/discussion/146346/how-to-return-a-result-that-matches-2-column-criteria-from-another-sheet2026-04-27T17:38:08+00:00 https://community.smartsheet.com/discussion/146354/formula-to-indicate-current-month-in-90-day-grace-period-for-26-certifications2026-04-27T14:21:20+00:00 https://community.smartsheet.com/discussion/146334/adding-an-image-to-a-sheet-cell-in-mobile-view-on-mobile-app-seems-to-have-stopped-working2026-04-27T13:48:52+00:00 https://community.smartsheet.com/discussion/146361/networkdays2026-04-24T20:42:49+00:00 https://community.smartsheet.com/discussion/146353/simplifying-index-match-function2026-04-24T17:51:34+00:00 https://community.smartsheet.com/discussion/146351/text-to-number-issue2026-04-24T16:42:11+00:00 https://community.smartsheet.com/discussion/146319/how-to-reference-project-metadata-and-display-sum-of-as-metric-value-on-a-dashboard2026-04-24T11:41:15+00:00 https://community.smartsheet.com/discussion/123657/email-automation-with-attachments2026-04-24T07:14:03+00:00 https://community.smartsheet.com/discussion/142839/attaching-a-message-sent-to-vendor-acknowledging-contract2026-04-24T07:13:59+00:00 https://community.smartsheet.com/discussion/132279/attachment-auto-email2026-04-24T07:13:53+00:00 https://community.smartsheet.com/discussion/146229/some-users-unable-to-submit-smartsheet-forms-some-users-not-receiving-attachments-in-automated-email2026-04-24T07:13:50+00:00 https://community.smartsheet.com/discussion/136557/automated-hyperlink-url-within-anchor-text2026-04-24T07:13:36+00:00 https://community.smartsheet.com/discussion/72439/automated-emails-are-not-coming-from-the-owner-of-the-sheet2026-04-24T07:13:23+00:00 https://community.smartsheet.com/discussion/79801/send-attachments-using-power-automate2026-04-24T07:13:00+00:00 https://community.smartsheet.com/discussion/73494/how-can-i-only-have-an-attachment-sent-via-a-workflow2026-04-24T07:12:33+00:00 https://community.smartsheet.com/discussion/139909/resource-planning-calculating-weekly-hours-remaining-for-a-project2026-04-24T07:11:23+00:00 https://community.smartsheet.com/discussion/146308/need-to-show-the-data-in-a-graphic2026-04-23T18:50:26+00:00 https://community.smartsheet.com/discussion/146299/indexx-match-help2026-04-23T11:17:54+00:00 https://community.smartsheet.com/discussion/146330/if-the-checkbox-is-checked-copy-the-row2026-04-23T11:09:57+00:00 https://community.smartsheet.com/discussion/146318/formula-help-please2026-04-22T18:47:25+00:00 https://community.smartsheet.com/discussion/146309/help-with-a-cross-sheet-formula-counting-unique-values-when-certain-parameters-are-met2026-04-22T17:36:02+00:00 https://community.smartsheet.com/discussion/146303/index-collect2026-04-22T14:53:35+00:00 https://community.smartsheet.com/discussion/146291/how-are-you-automating-rag-status-roll-ups-across-complex-project-hierarchies2026-04-22T13:23:04+00:00 https://community.smartsheet.com/discussion/146304/create-a-formula-to-return-a-check-mark2026-04-22T12:39:51+00:00 https://community.smartsheet.com/discussion/146310/unable-to-calculate-event-end-time-from-start-date-and-duration2026-04-22T12:34:31+00:00 https://community.smartsheet.com/discussion/146115/parent-child-rows-in-a-report-even-if-not-assigned-to-parent-row2026-04-22T01:04:21+00:00 https://community.smartsheet.com/discussion/146035/automation-workflow-not-including-attachments-in-notification-emails-correctly2026-04-21T19:32:58+00:00 https://community.smartsheet.com/discussion/146298/can-we-auto-create-the-row-link-as-a-hyperlink-to-autoconnect-to-that-row-yet2026-04-21T18:39:48+00:00 https://community.smartsheet.com/discussion/146292/how-to-create-a-dual-dynamic-list-of-unique-column-values-including-a-short-list-of-associated-values-per-unique-value2026-04-21T16:19:10+00:00 https://community.smartsheet.com/discussion/70569/elapsed-time-accounting-for-weekends2026-04-21T14:53:21+00:00 https://community.smartsheet.com/discussion/146290/countifs-cross-sheet-error2026-04-21T14:36:08+00:00 https://community.smartsheet.com/discussion/47206/rag-roll-up-formula2026-04-21T14:32:52+00:00 https://community.smartsheet.com/discussion/89935/hey-guys-is-there-a-way-in-smartsheet-to-return-the-day-of-the-week-based-on-a-date-entered2026-04-21T07:58:28+00:00 https://community.smartsheet.com/discussion/146279/what-is-the-best-way-to-bring-in-data-from-another-sheet-without-a-direct-matching-column-on-both-sheets2026-04-20T22:31:10+00:00 https://community.smartsheet.com/discussion/146271/how-to-maintain-permanent-inventory-levels-when-source-data-is-deleted-weekly2026-04-20T10:54:18+00:00 https://community.smartsheet.com/discussion/146231/sum-if-multiple-criteria-matches-across-2-sheets2026-04-20T08:02:16+00:00 https://community.smartsheet.com/discussion/146211/helper-formula-for-filtering-contradicting-status2026-04-20T02:53:22+00:00 https://community.smartsheet.com/discussion/146268/contact-field-email-extract2026-04-19T12:58:59+00:00 https://community.smartsheet.com/discussion/146261/sum-with-multiple-conditions2026-04-17T19:18:24+00:00 https://community.smartsheet.com/discussion/146259/returning-a-percentage-based-on-particular-criteria2026-04-17T16:37:15+00:00 https://community.smartsheet.com/discussion/146237/displaying-an-overall-completion-within-a-dashboard2026-04-17T16:17:23+00:00 https://community.smartsheet.com/discussion/146147/automating-date-tracking-and-reminders2026-04-17T12:26:43+00:00 https://community.smartsheet.com/discussion/146235/html-not-working-on-forms2026-04-17T11:15:18+00:00 https://community.smartsheet.com/discussion/146238/i-need-help-creating-a-formula2026-04-17T08:43:19+00:00 https://community.smartsheet.com/discussion/105079/formula-cell-reference-limit-25-000-000-not-refreshing2026-04-16T21:06:55+00:00 https://community.smartsheet.com/discussion/146233/attach-checkbox-column-in-the-source-sheet-to-a-specific-user-per-row2026-04-16T19:48:14+00:00 https://community.smartsheet.com/discussion/146236/can-you-have-a-column-showing-a-driving-predecessor-for-a-task2026-04-16T19:31:44+00:00 https://community.smartsheet.com/discussion/146216/problems-with-turning-off-automatic-backups2026-04-16T13:42:49+00:00 https://community.smartsheet.com/discussion/146227/average-by-section-within-a-column2026-04-16T13:41:04+00:00 https://community.smartsheet.com/discussion/146212/rankeq-with-index-collect-across-multiple-sheets2026-04-16T03:14:31+00:00 https://community.smartsheet.com/discussion/146200/how-do-i-get-the-exact-number-of-years-based-on-the-date-column-no-more-rounding-up2026-04-15T18:42:05+00:00 https://community.smartsheet.com/discussion/146185/automated-number-assignment-sorting-formula2026-04-15T16:36:24+00:00 https://community.smartsheet.com/discussion/146223/how-to-return-a-blank-when-searching-for-max-date-and-one-of-the-dates-is-blank2026-04-15T16:09:48+00:00 https://community.smartsheet.com/discussion/146195/next-outreach-due-formula-help2026-04-15T15:12:39+00:00 https://community.smartsheet.com/discussion/146188/indexing-from-multiple-sheets2026-04-15T12:09:39+00:00 https://community.smartsheet.com/discussion/85028/alerts-for-max-rows2026-04-15T01:03:33+00:00 https://community.smartsheet.com/discussion/51396/alerts-for-when-nearing-5000-row-limit2026-04-15T00:57:32+00:00 https://community.smartsheet.com/discussion/146209/sumif-formula-help2026-04-14T23:49:26+00:00 https://community.smartsheet.com/discussion/146205/can-i-count-cells-between-number-thresholds-if-the-cell-also-has-text-in-it2026-04-14T18:46:52+00:00 https://community.smartsheet.com/discussion/146174/converting-excel-formula2026-04-14T18:43:07+00:00 https://community.smartsheet.com/discussion/146201/ryg-formula-based-on-due-date-and-percentage-complete2026-04-14T17:00:44+00:00 https://community.smartsheet.com/discussion/146184/formula-for-imported-data2026-04-14T13:57:54+00:00 https://community.smartsheet.com/discussion/146197/of-occurrences-formula2026-04-14T13:57:12+00:00 https://community.smartsheet.com/discussion/146051/index-match-formula-returning-some-not-all-values2026-04-14T12:47:30+00:00 https://community.smartsheet.com/discussion/146158/match-sumifs-formula2026-04-14T12:46:43+00:00 https://community.smartsheet.com/discussion/146148/extracting-multiple-data-from-one-cell-into-multiple-cells-same-row2026-04-14T12:46:20+00:00 https://community.smartsheet.com/discussion/146183/count-projects-completed-in-a-date-range2026-04-13T20:18:35+00:00 https://community.smartsheet.com/discussion/146187/setting-up-a-metric-sheet-to-calculate-the-ytd-sum-but-not-show-data-in-future-months2026-04-13T20:03:33+00:00 https://community.smartsheet.com/discussion/146180/count-if-s-formula-help2026-04-13T18:03:50+00:00 https://community.smartsheet.com/discussion/146077/complicated-if-function2026-04-11T06:47:35+00:00 https://community.smartsheet.com/discussion/146151/calculating-totals2026-04-10T17:57:21+00:00 https://community.smartsheet.com/discussion/146082/delayed-automation2026-04-10T17:05:14+00:00 https://community.smartsheet.com/discussion/146116/wbs-helper-columns-column2026-04-09T18:20:55+00:00 https://community.smartsheet.com/discussion/146074/expired-date-formula2026-04-09T16:52:49+00:00 https://community.smartsheet.com/discussion/146124/if-formula-working-on-some-and-not-on-other-items-in-column2026-04-09T10:58:43+00:00 https://community.smartsheet.com/discussion/146105/record-a-date-from-to2026-04-08T19:10:33+00:00 https://community.smartsheet.com/discussion/146106/construction-phase-count-formula2026-04-08T19:08:55+00:00 https://community.smartsheet.com/discussion/145983/flagging-tasks-as-blocked-if-predecessors-are-past-due2026-04-08T14:11:16+00:00 https://community.smartsheet.com/discussion/146083/calculating-sums-based-on-criteria-1-and-22026-04-08T12:46:31+00:00 https://community.smartsheet.com/discussion/146090/contact-cell-for-approval-flow2026-04-08T06:54:21+00:00 https://community.smartsheet.com/discussion/146072/formula-shows-unparsable2026-04-07T15:27:00+00:00 https://community.smartsheet.com/discussion/145998/stuck-on-a-countif-formula-to-use2026-04-07T11:52:37+00:00 https://community.smartsheet.com/discussion/146069/logic-for-if-this-and-if-that-then2026-04-07T06:50:52+00:00 https://community.smartsheet.com/discussion/146064/using-sumifs-with-a-date-qualification2026-04-06T18:43:26+00:00 https://community.smartsheet.com/discussion/146020/critical-path-not-showing-in-gantt-nor-list-view-though-dependencies-are-enabled2026-04-06T15:30:37+00:00 https://community.smartsheet.com/discussion/146056/same-formula-weeknumber-date-row-different-result2026-04-06T13:14:38+00:00 https://community.smartsheet.com/discussion/135588/help-with-index-collect-with-a-max-collect2026-04-06T13:04:11+00:00 https://community.smartsheet.com/discussion/146008/is-there-a-way-to-break-out-found-rows-from-a-linked-sheet-into-sequential-rows-in-a-new-sheet2026-04-06T13:01:39+00:00 https://community.smartsheet.com/discussion/146054/failed-to-import-error2026-04-04T02:42:45+00:00 https://community.smartsheet.com/discussion/146040/helper-column-parent-rows2026-04-03T22:29:58+00:00 https://community.smartsheet.com/discussion/146052/subtracting-months-from-a-date-error-invalid-value2026-04-03T21:35:25+00:00 https://community.smartsheet.com/discussion/146031/duration-based-on-time-formula-question2026-04-03T16:58:26+00:00 https://community.smartsheet.com/discussion/146011/help-with-a-formula-or-formuals2026-04-03T16:45:58+00:00 https://community.smartsheet.com/discussion/146046/are-you-able-to-calculate-minutes-seconds-and-milliseconds-in-smartsheet2026-04-03T16:00:01+00:00 https://community.smartsheet.com/discussion/74957/parent-child-lines-to-be-populated-from-form2026-04-03T14:14:24+00:00 https://community.smartsheet.com/discussion/146029/cant-transfer-ownership-of-a-workspace2026-04-03T12:15:17+00:00 https://community.smartsheet.com/discussion/145999/download-list-of-saved-automation-workflows-into-excel2026-04-02T17:03:05+00:00 https://community.smartsheet.com/discussion/145929/nested-if-statement2026-04-02T12:58:39+00:00 https://community.smartsheet.com/discussion/95821/multi-select-count2026-04-02T12:10:11+00:00 https://community.smartsheet.com/discussion/146027/automatic-notification-in-form-entry2026-04-02T12:09:27+00:00 https://community.smartsheet.com/discussion/146024/having-trouble-creating-a-multiplication-formula2026-04-02T11:58:37+00:00 https://community.smartsheet.com/discussion/146013/counting-parent-in-progress-rows2026-04-02T11:42:25+00:00 https://community.smartsheet.com/discussion/146010/help-with-a-formula-or-formulas2026-04-01T19:40:17+00:00 https://community.smartsheet.com/discussion/146012/combining-contact-cell-contents2026-04-01T19:35:04+00:00 https://community.smartsheet.com/discussion/145994/formula-when-using-sheet-hierarchy2026-04-01T17:50:57+00:00 https://community.smartsheet.com/discussion/146005/help-with-formula-please2026-04-01T16:54:38+00:00 https://community.smartsheet.com/discussion/146000/concatenate-with-a-date2026-04-01T14:59:59+00:00 https://community.smartsheet.com/discussion/145962/skip-wbs-vs-deleting-task2026-04-01T11:55:46+00:00 https://community.smartsheet.com/discussion/84916/how-do-i-add-multiple-dates-to-be-selected-on-a-form2026-03-31T18:49:34+00:00 https://community.smartsheet.com/discussion/145938/can-i-set-up-automation-to-copy-a-row-to-another-sheet-and-duplicate-there-based-on-specific-criteria2026-03-31T09:35:24+00:00 https://community.smartsheet.com/discussion/145953/continuous-row-numbering-not-working-for-blank-rows2026-03-31T04:14:11+00:00 https://community.smartsheet.com/discussion/145927/viewing-last-updated-in-sheet2026-03-30T18:26:55+00:00 https://community.smartsheet.com/discussion/145930/how-can-i-get-this-formula-to-work2026-03-30T17:02:14+00:00 https://community.smartsheet.com/discussion/145952/conditional-formatting-broken-in-table-view2026-03-30T14:41:58+00:00 https://community.smartsheet.com/discussion/145932/date-function2026-03-30T12:11:42+00:00 https://community.smartsheet.com/discussion/145949/count-and-lookup-based2026-03-30T04:56:56+00:00 https://community.smartsheet.com/discussion/145951/use-dependencies-to-set-start-and-end-dates-independently2026-03-30T04:34:32+00:00 https://community.smartsheet.com/discussion/145950/count-if-formula-to-retrieve-multiple-criteria2026-03-29T00:17:52+00:00 https://community.smartsheet.com/discussion/145948/time-stamping-a-document-within-an-approval-workflow2026-03-27T22:22:30+00:00 https://community.smartsheet.com/discussion/145900/automation-message-to-specific-contact-with-only-their-relavant-entries2026-03-27T22:22:17+00:00 https://community.smartsheet.com/discussion/145942/vlookup-to-gather-monthly-adoption-number-based-on-country2026-03-27T19:34:08+00:00 https://community.smartsheet.com/discussion/132933/returning-cell-based-on-2-criteria-in-another-sheet2026-03-27T17:39:33+00:00 https://community.smartsheet.com/discussion/145924/calculating-time-minutes-and-seconds2026-03-27T16:42:11+00:00 https://community.smartsheet.com/discussion/145936/dropdown-is-not-showing-link-to-another-sheet-option2026-03-27T15:32:57+00:00 https://community.smartsheet.com/discussion/145934/pulling-values-from-referenced-sheet-cell-where-mutliple-values-exist-in-the-cell2026-03-27T12:42:03+00:00 https://community.smartsheet.com/discussion/145893/dates-in-charts2026-03-27T11:49:40+00:00 https://community.smartsheet.com/discussion/103407/formula-to-change-upper-case-to-all-lower-case2026-03-26T22:47:20+00:00 https://community.smartsheet.com/discussion/98870/upper-case-for-first-letter-of-the-word2026-03-26T22:42:42+00:00 https://community.smartsheet.com/discussion/145819/what-is-the-best-practice-for-referencing-data-in-another-sheet2026-03-26T20:18:49+00:00 https://community.smartsheet.com/discussion/145919/need-formula-help2026-03-26T18:36:57+00:00 https://community.smartsheet.com/discussion/145918/lookup-value-and-count-based-on-the-input-criteria2026-03-26T16:06:21+00:00 https://community.smartsheet.com/discussion/145915/function-assistance2026-03-26T15:31:44+00:00 https://community.smartsheet.com/discussion/145871/need-some-formula-assistance2026-03-26T14:36:09+00:00 https://community.smartsheet.com/discussion/145914/collect-function-and-validate-isdate2026-03-26T12:16:01+00:00 https://community.smartsheet.com/discussion/145910/formula-to-check-a-checkbox-based-on-status-of-another-sheet2026-03-26T12:13:07+00:00 https://community.smartsheet.com/discussion/143983/cell-reference-contact-list-text2026-03-26T11:31:07+00:00 https://community.smartsheet.com/discussion/145911/automation-that-sends-alerts-after-30-days-of-date-column2026-03-26T11:11:51+00:00 https://community.smartsheet.com/discussion/145867/can-i-create-dashboards-across-workspaces2026-03-25T13:59:14+00:00 https://community.smartsheet.com/discussion/145692/anyone-resolved-automatically-adding-rows-to-a-sheet-based-on-a-trigger-value2026-03-24T09:45:33+00:00 https://community.smartsheet.com/discussion/145864/how-do-i-get-a-parent-row-to-change-based-off-a-child-row-value2026-03-23T20:36:34+00:00 https://community.smartsheet.com/discussion/145868/cross-sheet-formulas-not-returning-all-results2026-03-23T20:07:08+00:00 https://community.smartsheet.com/discussion/145862/smartsheet-formula-for-dynamic-mm-yyyy-display2026-03-23T17:37:11+00:00 https://community.smartsheet.com/discussion/145837/row-sum-of-expected2026-03-23T15:35:23+00:00 https://community.smartsheet.com/discussion/139766/freeze-rows2026-03-23T13:33:24+00:00 https://community.smartsheet.com/discussion/145797/how-can-i-combine-multiple-percentages-into-one-cumulative-percentage2026-03-23T08:24:50+00:00 https://community.smartsheet.com/discussion/145807/auto-populate-parent-child-rows-in-a-separate-sheet2026-03-20T21:39:59+00:00 https://community.smartsheet.com/discussion/145833/how-do-i-run-this-report2026-03-20T15:52:01+00:00 https://community.smartsheet.com/discussion/145838/adding-image-to-a-pdf-generated-document2026-03-20T15:25:55+00:00 https://community.smartsheet.com/discussion/145810/date-minus-of-days-to-get-new-date2026-03-20T14:18:23+00:00 https://community.smartsheet.com/discussion/145815/expected-formula2026-03-20T14:17:57+00:00 https://community.smartsheet.com/discussion/145795/older-than-3-years-and-status-set-to-closed2026-03-20T12:13:24+00:00 https://community.smartsheet.com/discussion/145835/how-to-format-salesforce-date-in-smartsheet-for-30-day-archiving-automation2026-03-20T12:10:04+00:00 https://community.smartsheet.com/discussion/145814/cross-sheet-formula-to-bring-back-name-and-count-for-that-name2026-03-20T12:02:06+00:00 https://community.smartsheet.com/discussion/145831/min-collect-function-issues2026-03-19T22:15:29+00:00 https://community.smartsheet.com/discussion/145821/multiple-forms-on-single-sheet2026-03-19T18:55:17+00:00 https://community.smartsheet.com/discussion/145811/multiple-if2026-03-19T18:06:46+00:00 https://community.smartsheet.com/discussion/145808/stacked-if-statement-using-and-and-or2026-03-19T15:41:19+00:00 https://community.smartsheet.com/discussion/145791/countif-by-month-in-date2026-03-19T13:57:21+00:00 https://community.smartsheet.com/discussion/145790/sum-if-match-formula2026-03-19T12:07:51+00:00 https://community.smartsheet.com/discussion/145787/formula-working-for-one-data-value-but-not-another2026-03-19T12:07:27+00:00 https://community.smartsheet.com/discussion/145735/need-help-with-date-calculation-formula2026-03-19T12:06:51+00:00 https://community.smartsheet.com/discussion/145789/automation-of-weekly-updates2026-03-19T08:11:02+00:00 https://community.smartsheet.com/discussion/143012/return-a-value-when-one-date-is-less-than-another2026-03-18T17:57:51+00:00 https://community.smartsheet.com/discussion/145778/countifs-formula-across-sheets2026-03-18T16:37:25+00:00 https://community.smartsheet.com/discussion/145781/pull-prices-through-to-a-sheet-using-a-date-range-to-keep-historical-data2026-03-18T14:07:19+00:00 https://community.smartsheet.com/discussion/107041/work-around-to-500-row-copy-and-paste-limitations2026-03-17T22:13:51+00:00 https://community.smartsheet.com/discussion/145771/sum-values-from-child-rows-automatically-with-formula-while-allowing-manual-data-entry-into-child-row-cells2026-03-17T21:53:46+00:00 https://community.smartsheet.com/discussion/145618/need-help-calculating-hours-allocated-per-week-for-team-members2026-03-17T20:56:57+00:00 https://community.smartsheet.com/discussion/145763/autopopulate-cells-else-new-entry2026-03-17T18:49:00+00:00 https://community.smartsheet.com/discussion/138650/reference-the-value-in-the-row-above-and-change-this-cell-value-as-a-result2026-03-17T14:04:36+00:00 https://community.smartsheet.com/discussion/145753/query-extract-day-thu-from-date-column2026-03-17T12:34:51+00:00 https://community.smartsheet.com/discussion/145643/count-completion-of-checked-items-by-each-sub-project2026-03-16T17:24:50+00:00 https://community.smartsheet.com/discussion/145718/permanent-row-ids-without-using-auto-id2026-03-16T14:31:57+00:00 https://community.smartsheet.com/discussion/145746/formula-to-display-weekday-horizontally2026-03-16T14:09:51+00:00 https://community.smartsheet.com/discussion/145724/formula-help-for-index-match-or-is-it-index-collect2026-03-16T13:59:11+00:00 https://community.smartsheet.com/discussion/145720/capturing-the-most-recent-change2026-03-13T22:13:49+00:00 https://community.smartsheet.com/discussion/145726/table-view-dropdown-sheet-link-is-dropping-zeros2026-03-13T14:43:57+00:00 https://community.smartsheet.com/discussion/145706/autopopulate-copy-certain-cells-to-another-sheet2026-03-13T14:19:01+00:00 https://community.smartsheet.com/discussion/145719/countifs-formula-between-two-criteria2026-03-13T13:31:38+00:00 https://community.smartsheet.com/discussion/145657/how-to-add-multiple-costs-from-dropdown-menu-items2026-03-12T17:31:33+00:00 https://community.smartsheet.com/discussion/145684/check-a-box-if-date-is-in-the-past-or-in-the-60-days2026-03-12T15:04:24+00:00 https://community.smartsheet.com/discussion/101610/how-to-extract-time-from-date-created-auto-column2026-03-12T14:53:48+00:00 https://community.smartsheet.com/discussion/145596/keeping-attachments-with-index-row-value2026-03-12T14:31:32+00:00 https://community.smartsheet.com/discussion/145662/countif-formula-not-counting-correctly2026-03-12T00:15:05+00:00 https://community.smartsheet.com/discussion/145661/move-row-action-getting-moved-rows-to-the-top-of-the-sheet2026-03-11T21:32:58+00:00 https://community.smartsheet.com/discussion/145668/time-elapsed-to-today-in-months-years2026-03-11T19:54:54+00:00 https://community.smartsheet.com/discussion/145659/how-to-trigger-an-action-from-one-smartsheet-to-another2026-03-11T19:15:35+00:00 https://community.smartsheet.com/discussion/145673/conditional-formatting-not-working2026-03-11T18:59:16+00:00 https://community.smartsheet.com/discussion/145681/update-dropdown-list2026-03-11T18:55:07+00:00 https://community.smartsheet.com/discussion/145664/formatting-not-working2026-03-11T14:06:13+00:00 https://community.smartsheet.com/discussion/145646/sheet-summary-formula-to-pull-month-and-fy-based-on-highest-value2026-03-11T14:01:41+00:00 https://community.smartsheet.com/discussion/144946/new-links-disappear-urgent2026-03-11T08:25:24+00:00 https://community.smartsheet.com/discussion/145637/countifs-referencing-another-sheet2026-03-11T02:55:14+00:00 https://community.smartsheet.com/discussion/145651/complete-calculation-issue2026-03-10T17:54:14+00:00 https://community.smartsheet.com/discussion/145642/formula-returning-2-suddenly-other-cells-same-formula-not-returning-the-22026-03-10T17:50:12+00:00 https://community.smartsheet.com/discussion/145644/formulas-reading-from-row-above2026-03-10T14:06:46+00:00 https://community.smartsheet.com/discussion/70150/how-to-get-an-average-of-multiple-symbols-harvey-balls-on-a-single-row2026-03-10T14:00:24+00:00 https://community.smartsheet.com/discussion/64977/convert-numbers-to-words2026-03-10T12:07:12+00:00 https://community.smartsheet.com/discussion/145588/dynamic-array-formula-help2026-03-09T21:58:54+00:00 https://community.smartsheet.com/discussion/145629/counting-value-repeats-since-last-distinct-value2026-03-09T19:05:18+00:00 https://community.smartsheet.com/discussion/145574/helper-row-and-determining-the-earlier-of-2-finish-dates2026-03-09T14:00:47+00:00 https://community.smartsheet.com/discussion/145608/calculation-for-parent-overview2026-03-09T12:11:34+00:00 https://community.smartsheet.com/discussion/145573/index-match-errors2026-03-09T11:48:51+00:00 https://community.smartsheet.com/discussion/145582/gantt-presentation2026-03-07T15:11:09+00:00 https://community.smartsheet.com/discussion/145042/adding-ytd-totals-without-using-sheet-summary-fields2026-03-06T23:57:31+00:00 https://community.smartsheet.com/discussion/145439/how-do-you-create-a-dynamic-list-of-unique-values-from-multiple-sheets2026-03-06T23:47:08+00:00 https://community.smartsheet.com/discussion/145613/countifs-formula-based-on-status-and-due-date2026-03-06T19:17:35+00:00 https://community.smartsheet.com/discussion/145583/how-do-i-list-all-predecessors-direct-and-indirect-for-a-given-row2026-03-06T19:03:48+00:00 https://community.smartsheet.com/discussion/145603/checkbox-evaluates-differently2026-03-06T15:53:53+00:00 https://community.smartsheet.com/discussion/145422/ranking-when-duplicates2026-03-06T15:45:19+00:00 https://community.smartsheet.com/discussion/145553/help-need-by-if-formula2026-03-06T09:14:09+00:00 https://community.smartsheet.com/discussion/145518/how-to-calculate-capacity-based-on-days-allocation-and-otoo-request-that-is-on-a-separate-sheet2026-03-05T16:41:57+00:00 https://community.smartsheet.com/discussion/145546/bring-data-from-source-sheet-in-to-separate-columns-in-data-sheet2026-03-05T14:41:28+00:00 https://community.smartsheet.com/discussion/145550/flag-projects-at-risk2026-03-05T09:21:06+00:00 https://community.smartsheet.com/discussion/145525/health-indicator-claculation2026-03-05T08:37:46+00:00 https://community.smartsheet.com/discussion/145566/conditional-formatting-in-rows-resulting-from-formulas2026-03-04T20:05:38+00:00 https://community.smartsheet.com/discussion/144923/countifs-contains-with-reference-form-another-sheet2026-03-04T19:43:20+00:00 https://community.smartsheet.com/discussion/82029/how-to-quickly-find-a-column-by-its-name-in-a-sheet2026-03-04T18:59:41+00:00 https://community.smartsheet.com/discussion/145536/separating-text-formula2026-03-04T18:45:38+00:00 https://community.smartsheet.com/discussion/145560/automation-rule-change-status-to-in-progress-based-on-complete-between-1-and-992026-03-04T17:39:43+00:00 https://community.smartsheet.com/discussion/145403/need-help-returning-concatenation-of-parent-and-task2026-03-04T13:16:04+00:00 https://community.smartsheet.com/discussion/145528/using-multiple-sheets-as-resource-allocation-tool-allocations-not-updating-based-on-date-changes2026-03-04T13:07:08+00:00 https://community.smartsheet.com/discussion/145539/unparseable-error-in-sheet-summary-field-formula2026-03-04T13:04:00+00:00 https://community.smartsheet.com/discussion/145459/resource-allocation-changing-duration2026-03-04T09:33:21+00:00 https://community.smartsheet.com/discussion/145532/formula-in-start-date-in-project-plan2026-03-03T17:24:41+00:00 https://community.smartsheet.com/discussion/145280/rows-could-not-be-added-to-the-destination-sheet-because-it-did-not-have-enough-cells-remaining2026-03-03T13:33:06+00:00 https://community.smartsheet.com/discussion/117930/cross-reference-sheet-max-limit2026-03-02T23:53:08+00:00 https://community.smartsheet.com/discussion/145487/sheet-name-links-not-taking-user-to-correct-sheet-row2026-03-02T14:14:34+00:00 https://community.smartsheet.com/discussion/136681/user-clicks-sheet-name-in-report-takes-them-to-incorrect-row-on-source-sheet2026-03-02T14:13:23+00:00 https://community.smartsheet.com/discussion/145499/formula-limits2026-03-02T09:27:23+00:00 https://community.smartsheet.com/discussion/145492/customizing-views2026-02-27T23:54:27+00:00 https://community.smartsheet.com/discussion/145482/calculate-days-remaining-until-task-due-date2026-02-27T19:10:40+00:00 https://community.smartsheet.com/discussion/145494/averageif-with-or-function2026-02-27T17:39:16+00:00 https://community.smartsheet.com/discussion/145472/formatting-values-with-join-collect2026-02-27T17:37:20+00:00 https://community.smartsheet.com/discussion/145100/how-to-count-one-name-in-a-multiple-contacts-per-cell-column2026-02-27T15:33:19+00:00 https://community.smartsheet.com/discussion/145468/complete-not-working-even-when-dependencies-are-enabled2026-02-27T14:45:25+00:00 https://community.smartsheet.com/discussion/145475/split-one-intake-row-into-multiple-rows-in-another-sheet-automation-bridge-help2026-02-27T12:44:48+00:00 https://community.smartsheet.com/discussion/145481/i-use-the-sum-children-formula-and-it-is-not-adding-all-rows-especially-the-last-row-that-was-added-what-are-the-reasons-why-and-how-to-fix-it2026-02-27T12:37:12+00:00 https://community.smartsheet.com/discussion/145428/need-help-with-collect-or-index-or-lookup-help-please2026-02-26T20:16:53+00:00 https://community.smartsheet.com/discussion/145427/join-collect-formula2026-02-26T18:48:11+00:00 https://community.smartsheet.com/discussion/138176/too-many-cross-sheet-references2026-02-26T18:20:04+00:00 https://community.smartsheet.com/discussion/139453/how-do-i-reduce-cross-sheet-references-my-sheet-tells-me-i-have-reached-the-max-number2026-02-26T18:05:01+00:00 https://community.smartsheet.com/discussion/145455/ai-is-no-match-for-the-smartsheet-community2026-02-26T17:25:35+00:00 https://community.smartsheet.com/discussion/145379/workflow-weirdness-auto-updating-a-status2026-02-26T16:15:39+00:00 https://community.smartsheet.com/discussion/145457/networkdays-formula-returns-unparseable2026-02-26T11:34:29+00:00 https://community.smartsheet.com/discussion/145445/does-smartsheet-have-an-equivalent-to-excels-name-manager-and-lambda2026-02-25T23:50:11+00:00 https://community.smartsheet.com/discussion/74431/copy-sheets-and-references2026-02-25T23:13:51+00:00 https://community.smartsheet.com/discussion/145447/issue-with-countifs-formula-referencing-auto-number-column-in-smartsheet2026-02-25T20:47:38+00:00 https://community.smartsheet.com/discussion/145442/networkdays-bring-back-invalid-data-type-error2026-02-25T19:15:19+00:00 https://community.smartsheet.com/discussion/145435/help-with-functions-for-attendance-tracker2026-02-25T18:11:29+00:00 https://community.smartsheet.com/discussion/145434/tracking-days2026-02-25T18:09:07+00:00 https://community.smartsheet.com/discussion/145437/copy-single-cell-to-cross-reference-sheet2026-02-25T17:55:05+00:00 https://community.smartsheet.com/discussion/145412/formula-not-calculating-the-correct-number2026-02-25T14:45:55+00:00 https://community.smartsheet.com/discussion/145419/how-do-i-use-ai-for-summary-formulas2026-02-25T13:31:10+00:00 https://community.smartsheet.com/discussion/145432/number-of-days-from-a-given-date-against-the-current-date2026-02-25T12:56:13+00:00 https://community.smartsheet.com/discussion/115306/is-it-possible-to-transfer-references-between-sheets2026-02-24T20:35:49+00:00 https://community.smartsheet.com/discussion/115736/copy-references-from-one-sheet-to-another-individual-or-bulk-add-multiple-references2026-02-24T20:21:41+00:00 https://community.smartsheet.com/discussion/108249/return-the-most-recent-result-that-is-not-blank2026-02-24T17:16:25+00:00 https://community.smartsheet.com/discussion/145415/days-late-formula-not-working2026-02-24T15:52:02+00:00 https://community.smartsheet.com/discussion/145386/using-index-match-for-a-master-sheet2026-02-24T15:12:34+00:00 https://community.smartsheet.com/discussion/145406/formula-assistance-unparseable2026-02-23T23:01:53+00:00 https://community.smartsheet.com/discussion/133408/download-column-names-column-types2026-02-23T20:22:32+00:00 https://community.smartsheet.com/discussion/145399/formula-help-please2026-02-23T18:28:52+00:00 https://community.smartsheet.com/discussion/145316/blocks-for-vacations2026-02-23T17:23:18+00:00 https://community.smartsheet.com/discussion/135754/maxif-next-date-to-review2026-02-23T17:06:21+00:00 https://community.smartsheet.com/discussion/35946/maxifs-alternative2026-02-23T16:21:11+00:00 https://community.smartsheet.com/discussion/145397/doing-a-mass-update-of-sheet-reference-names2026-02-23T13:44:07+00:00 https://community.smartsheet.com/discussion/145395/workaround-to-copy-rows-from-sheet-with-cr-formulas2026-02-23T13:38:26+00:00 https://community.smartsheet.com/discussion/145390/countifs-formula-to-add-multiple-criteria-from-same-column-source2026-02-23T13:29:53+00:00 https://community.smartsheet.com/discussion/145340/how-to-use-a-formula-to-popualte-a-status-bar-symbol2026-02-23T13:29:38+00:00 https://community.smartsheet.com/discussion/145376/sum-value-across-multiple-rows2026-02-23T09:32:29+00:00 https://community.smartsheet.com/discussion/145394/what-formula-is-best-to-summarize-dropdown-lists-by-options2026-02-22T17:33:17+00:00 https://community.smartsheet.com/discussion/132736/how-can-i-document-formulas-used-on-a-sheet2026-02-20T23:08:44+00:00 https://community.smartsheet.com/discussion/145371/generating-documents2026-02-20T21:15:58+00:00 https://community.smartsheet.com/discussion/82028/planned-dates-vs-actual-dates-with-date-variance-and-gantt-chart2026-02-20T16:26:33+00:00 https://community.smartsheet.com/discussion/145355/workaround-for-assigning-two-random-task-owners-multiple-auto-number-columns2026-02-20T15:49:16+00:00 https://community.smartsheet.com/discussion/105210/formula-to-calculate-days-lapsed-between-2-dates-but-only-starts-when-date-is-reached2026-02-20T01:21:48+00:00 https://community.smartsheet.com/discussion/20941/view-formulas-globally-in-a-sheet2026-02-19T22:31:27+00:00 https://community.smartsheet.com/discussion/47541/options-to-display-all-formulas-functions-in-a-sheet2026-02-19T22:29:23+00:00 https://community.smartsheet.com/discussion/145346/stacked-if-statement-not-evaluating-all-value-if-false-options2026-02-19T21:59:26+00:00 https://community.smartsheet.com/discussion/145358/correct-formula-syntax-for-checking-for-excluding-blank-cells2026-02-19T21:45:10+00:00 https://community.smartsheet.com/discussion/106858/only-copy-certain-columns-to-a-new-sheet2026-02-19T15:27:03+00:00 https://community.smartsheet.com/discussion/145326/how-can-i-find-the-sum-using-contains-from-a-dropdown2026-02-19T14:25:38+00:00 https://community.smartsheet.com/discussion/145337/fx-help2026-02-19T14:25:20+00:00 https://community.smartsheet.com/discussion/145327/circular-references-and-parseable-errors-with-cells-that-contain-emojis-and-text-numbers2026-02-19T04:44:25+00:00 https://community.smartsheet.com/discussion/145333/check-box-for-start-date-and-end-date-that-fall-within-todays-date2026-02-19T04:40:40+00:00 https://community.smartsheet.com/discussion/145313/sum-collect-or-if-statements2026-02-18T20:42:38+00:00 https://community.smartsheet.com/discussion/145305/index-distinct-formula-suddenly-stopped-working-last-week2026-02-18T15:42:05+00:00 https://community.smartsheet.com/discussion/145287/formula-help-advanced-logic2026-02-18T15:24:44+00:00 https://community.smartsheet.com/discussion/145303/if-gant2026-02-18T13:03:08+00:00 https://community.smartsheet.com/discussion/145300/converting-drop-down-date-to-a-date-formatted-value2026-02-18T12:44:17+00:00 https://community.smartsheet.com/discussion/144177/generate-documents-not-working2026-02-18T10:18:10+00:00 https://community.smartsheet.com/discussion/110084/add-a-formula-column-to-multiple-sheets-efficiently2026-02-17T21:45:48+00:00 https://community.smartsheet.com/discussion/73130/possible-to-create-or-copy-a-new-column-with-same-dropdown-options-from-an-existing2026-02-17T21:38:14+00:00 https://community.smartsheet.com/discussion/145298/nested-if-functions2026-02-17T20:28:11+00:00 https://community.smartsheet.com/discussion/145101/need-help-fixing-formula-in-a-timeline-with-subtasks2026-02-17T12:41:14+00:00 https://community.smartsheet.com/discussion/87433/form-logic-decision-based-on-greater-than-or-less-than-comparison2026-02-16T23:06:08+00:00 https://community.smartsheet.com/discussion/145277/is-it-possible-to-subtract-a-duration-from-a-date-which-drives-the-start-date2026-02-16T18:30:24+00:00 https://community.smartsheet.com/discussion/119782/having-trouble-comparing-two-cells2026-02-16T15:20:29+00:00 https://community.smartsheet.com/discussion/145254/referencing-another-column-in-the-same-row-after-finding-the-min-with-criteria2026-02-16T14:52:54+00:00 https://community.smartsheet.com/discussion/145223/how-to-determine-the-last-two-lines-of-a-sheet-when-row-is-checked2026-02-16T14:52:26+00:00 https://community.smartsheet.com/discussion/145274/unable-to-edit-formulas2026-02-16T13:03:47+00:00 https://community.smartsheet.com/discussion/135346/is-there-a-way-to-show-a-particular-image-in-a-dashboard-depending-on-which-option-is-selected2026-02-16T09:25:50+00:00 https://community.smartsheet.com/discussion/145259/workaround-for-hyperlink2026-02-14T00:37:09+00:00 https://community.smartsheet.com/discussion/145264/set-a-value-on-one-sheet-if-that-sheets-row-id-exists-on-another-sheet-with-a-certain-status2026-02-13T19:43:53+00:00 https://community.smartsheet.com/discussion/145263/range-settings2026-02-13T19:26:23+00:00 https://community.smartsheet.com/discussion/145262/comparing-three-columns2026-02-13T19:26:05+00:00 https://community.smartsheet.com/discussion/145255/formula-for-if-checkbox-is-ticked2026-02-13T14:35:56+00:00 https://community.smartsheet.com/discussion/145246/how-to-calculate-the-number-of-submittals-completed-each-day2026-02-13T14:22:07+00:00 https://community.smartsheet.com/discussion/145250/stock-control2026-02-13T13:19:49+00:00 https://community.smartsheet.com/discussion/145242/if-calculations2026-02-13T12:53:40+00:00 https://community.smartsheet.com/discussion/145151/how-to-replace-a-contact-name-using-a-formula2026-02-13T05:43:56+00:00 https://community.smartsheet.com/discussion/145217/protect-formulas-within-cells-in-a-single-column-without-using-column-formula-or-locking-the-column2026-02-12T20:43:35+00:00 https://community.smartsheet.com/discussion/108324/help-with-conditional-formatting2026-02-12T19:16:31+00:00 https://community.smartsheet.com/discussion/98254/inserting-symbols-and-emojis2026-02-12T19:05:52+00:00 https://community.smartsheet.com/discussion/145072/changing-series-order-in-stacked-bar-chart2026-02-12T16:21:28+00:00 https://community.smartsheet.com/discussion/145231/status-to-red-once-the-deadline-is-reached2026-02-12T16:00:15+00:00 https://community.smartsheet.com/discussion/145237/avg-collect-divide-by-zero-error2026-02-12T15:54:31+00:00 https://community.smartsheet.com/discussion/145234/averageif-not-returning-correct-value2026-02-12T15:51:50+00:00 https://community.smartsheet.com/discussion/145134/how-would-i-add-in-a-month-based-off-a-date-in-another-column2026-02-12T12:12:52+00:00 https://community.smartsheet.com/discussion/145180/weighted-average-in-project-plans2026-02-11T21:35:57+00:00 https://community.smartsheet.com/discussion/145181/sheet-summary-formulas2026-02-11T21:24:30+00:00 https://community.smartsheet.com/discussion/145215/how-do-i-display-the-username-of-a-modifier-of-a-specific-column2026-02-11T19:44:12+00:00 https://community.smartsheet.com/discussion/145124/if-function-in-an-index-formula2026-02-11T19:35:48+00:00 https://community.smartsheet.com/discussion/145189/date-based-automation-not-working2026-02-11T15:01:59+00:00 https://community.smartsheet.com/discussion/145213/sumifs-value2026-02-11T15:01:18+00:00 https://community.smartsheet.com/discussion/144679/need-help-with-date-reporting-formula2026-02-11T13:47:42+00:00 https://community.smartsheet.com/discussion/142494/cross-sheet-copy-and-then-index-match-help-needed2026-02-10T20:15:36+00:00 https://community.smartsheet.com/discussion/84988/map-for-location-data2026-02-10T19:50:52+00:00 https://community.smartsheet.com/discussion/145192/cumulative-sum-that-adjusts-based-on-current-month2026-02-10T17:41:07+00:00 https://community.smartsheet.com/discussion/145176/mirror-row2026-02-10T17:33:10+00:00 https://community.smartsheet.com/discussion/105056/formula-for-a-parent-row-to-populate-status-based-on-children-status2026-02-10T17:05:17+00:00 https://community.smartsheet.com/discussion/145174/symbol-magically-appears-in-a-cell-that-is-copied-over-to-another-sheet2026-02-10T14:46:53+00:00 https://community.smartsheet.com/discussion/143968/best-way-to-cross-reference-multiple-sheets-for-repeated-values-only2026-02-10T13:42:04+00:00 https://community.smartsheet.com/discussion/145186/display-n-a-if-join-collect-formula-finds-no-result2026-02-10T12:35:08+00:00 https://community.smartsheet.com/discussion/145177/clock-in-and-out-with-lunch-time-stamps2026-02-10T08:06:59+00:00 https://community.smartsheet.com/discussion/145154/formula-to-find-data-in-table-with-multiple-columns-based-on-2-critera2026-02-09T20:54:43+00:00 https://community.smartsheet.com/discussion/145173/cell-linking2026-02-09T19:18:39+00:00 https://community.smartsheet.com/discussion/145162/formula-not-working-need-help-please-showing-as-incorrect-argument2026-02-09T19:05:54+00:00 https://community.smartsheet.com/discussion/145137/if-formula-to-return-highest-priority2026-02-09T09:22:11+00:00 https://community.smartsheet.com/discussion/137173/isolate-user-entered-value-in-multi-select-list2026-02-08T03:57:57+00:00 https://community.smartsheet.com/discussion/140055/cross-reference-sheet-average-number-of-days-between-two-columns-dates-while-excluding-blank-values2026-02-08T03:53:48+00:00 https://community.smartsheet.com/discussion/145088/index-match-suddenly-not-working2026-02-06T21:13:58+00:00 https://community.smartsheet.com/discussion/145130/how-to-display-proof-images-on-a-dashboard2026-02-06T17:22:56+00:00 https://community.smartsheet.com/discussion/145131/multi-part-calculation2026-02-06T15:03:56+00:00 https://community.smartsheet.com/discussion/145122/sheet-reference-limits2026-02-06T13:30:28+00:00 https://community.smartsheet.com/discussion/145108/risk-register-set-up2026-02-06T06:08:41+00:00 https://community.smartsheet.com/discussion/145116/how-can-i-exclude-one-column-from-an-automation-that-alerts-me-to-changes2026-02-06T06:07:30+00:00 https://community.smartsheet.com/discussion/145128/formula-for-2-values-whichever-is-larger2026-02-05T21:07:25+00:00 https://community.smartsheet.com/discussion/145099/formula-to-bring-dependent-values2026-02-05T18:00:02+00:00 https://community.smartsheet.com/discussion/145091/update-report-with-new-drop-down-options2026-02-05T17:50:42+00:00 https://community.smartsheet.com/discussion/144995/calendar-view-of-project-status-progression2026-02-05T16:45:14+00:00 https://community.smartsheet.com/discussion/145103/counting-results-from-a-index-match-returning-no-match2026-02-05T13:47:27+00:00 https://community.smartsheet.com/discussion/145076/01-01-70-view-activity-log-issue2026-02-05T08:07:51+00:00 https://community.smartsheet.com/discussion/144278/how-to-calculate-planned-in-father-rows2026-02-05T02:36:18+00:00 https://community.smartsheet.com/discussion/145098/multiple-if-condition-is-not-working2026-02-04T21:10:24+00:00 https://community.smartsheet.com/discussion/145079/flag-first-occurrence-as-unique-and-others-as-duplicate-by-person-date2026-02-04T21:07:57+00:00 https://community.smartsheet.com/discussion/145056/managing-dates2026-02-04T21:01:35+00:00 https://community.smartsheet.com/discussion/145060/including-attachments-in-message-only-automations2026-02-04T19:18:18+00:00 https://community.smartsheet.com/discussion/145087/reusing-a-formula-but-its-not-working-i-need-to-calculate-deviation-on-end-date2026-02-04T18:32:52+00:00 https://community.smartsheet.com/discussion/145067/adding-date-ranges-to-column-headers2026-02-04T18:16:41+00:00 https://community.smartsheet.com/discussion/145084/can-anyone-please-advise-if-im-using-the-correct-format-for-the-current-year-function2026-02-04T17:44:55+00:00 https://community.smartsheet.com/discussion/145081/formula-to-return-the-month2026-02-04T16:59:43+00:00 https://community.smartsheet.com/discussion/145074/returning-a-due-date-based-on-multiple-criteria2026-02-04T15:01:17+00:00 https://community.smartsheet.com/discussion/96167/sum-of-parent-rows-only-below-parent-and-child-rows2026-02-04T10:32:55+00:00 https://community.smartsheet.com/discussion/90791/month-function-sorting-in-report2026-02-03T17:39:12+00:00 https://community.smartsheet.com/discussion/145058/how-to-provide-a-link-to-a-specific-row-in-dynamic-view-for-end-users2026-02-03T17:00:47+00:00 https://community.smartsheet.com/discussion/145061/generate-formula-that-identifies-duplicate-entries-and-notates-most-recent-entry2026-02-03T16:43:28+00:00 https://community.smartsheet.com/discussion/144742/rolling-budget-spend-tracker2026-02-03T00:57:47+00:00 https://community.smartsheet.com/discussion/145025/countifs-has-and-and2026-02-02T16:51:25+00:00 https://community.smartsheet.com/discussion/145014/adding-two-countifs2026-02-02T16:15:14+00:00 https://community.smartsheet.com/discussion/145034/countifs-not-working-via-choosing-whole-column-or-selected-cells2026-02-02T13:15:04+00:00 https://community.smartsheet.com/discussion/145024/count-multiple-criteria-across-2-columns2026-02-02T09:27:13+00:00 https://community.smartsheet.com/discussion/145027/i-need-to-pull-certain-data-from-a-sheet-to-another-with-specific-criteria-such-as-completion-02026-02-01T16:14:18+00:00 https://community.smartsheet.com/discussion/144898/pull-content-from-multiple-rows-into-another-sheet2026-01-31T20:27:01+00:00 https://community.smartsheet.com/discussion/144347/weighted-average2026-01-31T20:10:17+00:00 https://community.smartsheet.com/discussion/144365/counting-dates2026-01-31T20:06:11+00:00 https://community.smartsheet.com/discussion/144928/is-anyone-else-struggling-with-duplicate-assignments-i-e-assigned-to-field2026-01-30T16:34:42+00:00 https://community.smartsheet.com/discussion/145004/return-a-date-from-another-sheet-based-on-two-columns-in-source-sheet2026-01-30T14:56:50+00:00 https://community.smartsheet.com/discussion/145013/error-on-index-match-formula2026-01-30T14:55:43+00:00 https://community.smartsheet.com/discussion/145002/if-contains-function2026-01-30T12:50:36+00:00 https://community.smartsheet.com/discussion/144992/health-ripple-effect-formula2026-01-30T12:42:03+00:00 https://community.smartsheet.com/discussion/144836/formulas2026-01-30T10:40:45+00:00 https://community.smartsheet.com/discussion/144952/can-smartsheet-add-sumif-statements-together-struggling2026-01-30T05:15:45+00:00 https://community.smartsheet.com/discussion/144964/harvey-ball-status-based-on-due-date2026-01-29T17:50:28+00:00 https://community.smartsheet.com/discussion/144976/added-2-years-to-date-only-want-to-populate-in-specific-fields2026-01-29T16:53:18+00:00 https://community.smartsheet.com/discussion/144981/fx-decimal-place-output-is-too-much2026-01-29T15:15:26+00:00 https://community.smartsheet.com/discussion/144954/join-collect-order-by-most-recent2026-01-29T14:54:54+00:00 https://community.smartsheet.com/discussion/144934/creating-data-to-populate-a-dashboard2026-01-29T14:52:18+00:00 https://community.smartsheet.com/discussion/98981/how-do-you-create-ytd-formulas-to-track-sums-during-a-specific-period2026-01-29T14:45:06+00:00 https://community.smartsheet.com/discussion/144969/dashboards-for-comparisons-from-year-to-year2026-01-29T12:26:01+00:00 https://community.smartsheet.com/discussion/144980/sum-children-formula-issue2026-01-29T11:01:58+00:00 https://community.smartsheet.com/discussion/144943/countifs-isdate-formula2026-01-29T03:17:54+00:00 https://community.smartsheet.com/discussion/144956/can-you-make-a-dropdown-option-dependent-upon-another-drop-down-parent-child2026-01-29T01:32:41+00:00 https://community.smartsheet.com/discussion/144974/dancing-with-the-stars2026-01-28T21:26:34+00:00 https://community.smartsheet.com/discussion/144963/how-to-phrase-a-question-for-the-ai-or-write-the-formula-for-myself-for-grouping-data2026-01-28T19:54:03+00:00 https://community.smartsheet.com/discussion/144958/calculating-time-in-smartsheet2026-01-28T15:33:28+00:00 https://community.smartsheet.com/discussion/144941/countif-isdate-function2026-01-27T21:05:56+00:00 https://community.smartsheet.com/discussion/143953/return-blank-when-count-total-is-zero2026-01-27T21:01:48+00:00 https://community.smartsheet.com/discussion/74027/using-smartsheet-to-book-workspaces-meeting-rooms2026-01-27T19:01:31+00:00 https://community.smartsheet.com/discussion/144920/rolling-view-timebound2026-01-27T17:34:29+00:00 https://community.smartsheet.com/discussion/144927/counting-specific-items-within-an-array-where-row-meets-criteria2026-01-27T15:58:24+00:00 https://community.smartsheet.com/discussion/71435/how-to-create-dependent-drop-down-lists2026-01-27T14:12:20+00:00 https://community.smartsheet.com/discussion/144919/pull-most-recent-date-from-another-sheet-based-on-two-criteria2026-01-27T13:08:14+00:00 https://community.smartsheet.com/discussion/144917/of-check-boxes2026-01-27T13:05:52+00:00 https://community.smartsheet.com/discussion/144915/adding-a-secondary-sheet-into-the-equation2026-01-27T12:14:41+00:00 https://community.smartsheet.com/discussion/144924/using-a-form-to-collect-data-on-a-sheet-specific-to-a-row2026-01-27T11:17:19+00:00 https://community.smartsheet.com/discussion/144918/countifs-from-two-columns-on-a-reference-sheet2026-01-26T20:31:19+00:00 https://community.smartsheet.com/discussion/144640/request-an-update-weekly-automation-only-worked-once-and-i-cant-figure-out-why2026-01-26T20:19:54+00:00 https://community.smartsheet.com/discussion/144910/adding-if-statement-in-a-formula2026-01-26T17:35:24+00:00 https://community.smartsheet.com/discussion/144907/counting-items-created-within-a-certain-date-range2026-01-26T15:14:39+00:00 https://community.smartsheet.com/discussion/144857/return-multiple-values-based-on-two-cells2026-01-26T09:23:51+00:00 https://community.smartsheet.com/discussion/144901/if-formula2026-01-24T16:13:16+00:00 https://community.smartsheet.com/discussion/144897/index-or-collect-with-or2026-01-24T07:00:00+00:00 https://community.smartsheet.com/discussion/144838/count-if-cell-is-not-blank2026-01-24T06:27:55+00:00 https://community.smartsheet.com/discussion/144891/how-to-pull-cell-data-from-one-sheet-to-another-based-on-criteria2026-01-23T21:07:38+00:00 https://community.smartsheet.com/discussion/144860/returning-a-link-if-two-cells-are-not-blank2026-01-23T17:59:14+00:00 https://community.smartsheet.com/discussion/144877/i-cannot-get-my-formula-to-return-complete-when-percent-complete-equals-1002026-01-23T17:47:16+00:00 https://community.smartsheet.com/discussion/144861/populating-data-into-another-sheet-when-certain-criteria-is-met2026-01-23T17:42:57+00:00 https://community.smartsheet.com/discussion/144841/formula-not-adding-correctly2026-01-23T13:46:36+00:00 https://community.smartsheet.com/discussion/144865/collect-a-unique-identifier-if-a-match-is-found2026-01-23T13:27:49+00:00 https://community.smartsheet.com/discussion/144866/formula-for-summary-field-pull-multiple-items-from-cell2026-01-22T20:58:13+00:00 https://community.smartsheet.com/discussion/144859/add-days-from-a-column-to-invoice-date2026-01-22T19:52:24+00:00 https://community.smartsheet.com/discussion/144855/countif-not-pulling-data2026-01-22T18:52:28+00:00 https://community.smartsheet.com/discussion/144854/using-report-information-in-a-new-sheet2026-01-22T16:57:26+00:00 https://community.smartsheet.com/discussion/144844/countif-formula-where-range-is-a-formula-column2026-01-22T15:38:12+00:00 https://community.smartsheet.com/discussion/144780/workaround-for-automation-email-to-receive-separately-and-not-bundled-in-one-e2026-01-22T08:31:46+00:00 https://community.smartsheet.com/discussion/144770/generate-ducuments-with-multilines2026-01-22T08:53:12+00:00 https://community.smartsheet.com/discussion/144826/looking-to-add-differentiators-how-can-i-do-that-without-using-rand2026-01-21T22:30:01+00:00 https://community.smartsheet.com/discussion/144666/formula-to-determine-number-of-plants-still-in-inventory-which-were-acquired-more-than-6-months-ago2026-01-21T22:31:39+00:00 https://community.smartsheet.com/discussion/144804/add-columns-through-global-update-that-contains-formulas-with-cross-references2026-01-21T22:31:44+00:00 https://community.smartsheet.com/discussion/144821/can-a-form-be-populated-via-url-from-multi-line-text2026-01-21T18:02:59+00:00 https://community.smartsheet.com/discussion/144823/averaging-percentage-from-3-columns-in-one-row2026-01-21T18:03:07+00:00 https://community.smartsheet.com/discussion/144774/calculating-start-and-end-dates-of-periods-into-dates-into-the-next-year2026-01-21T16:09:39+00:00 https://community.smartsheet.com/discussion/144805/sumif-with-and-function2026-01-21T16:19:26+00:00 https://community.smartsheet.com/discussion/144791/my-conditional-formatting-is-not-showing-consistently-in-my-reports-what-did-i-do-wrong2026-01-21T14:10:28+00:00 https://community.smartsheet.com/discussion/76850/help-with-formula2026-01-21T08:57:03+00:00 https://community.smartsheet.com/discussion/87816/dashboard-show-progress-using-project-phases-not-s2026-01-21T08:59:31+00:00 https://community.smartsheet.com/discussion/144788/how-can-i-restore-formulas-and-cell-links-in-a-sheet2026-01-20T20:57:56+00:00 https://community.smartsheet.com/discussion/105248/formula-for-changing-symbol-colors2026-01-20T20:57:18+00:00 https://community.smartsheet.com/discussion/144762/index-help-no-match2026-01-20T21:14:01+00:00 https://community.smartsheet.com/discussion/144795/how-do-i-show-incomplete-and-older-than-30-days2026-01-20T17:46:22+00:00 https://community.smartsheet.com/discussion/144790/sumifs-problem2026-01-20T16:29:40+00:00 https://community.smartsheet.com/discussion/144725/use-index-that-make-dynamic-formuale-in-the-row2026-01-20T15:07:39+00:00 https://community.smartsheet.com/discussion/144779/track-monthly-submissions-from-multiple-locations2026-01-20T15:16:45+00:00 https://community.smartsheet.com/discussion/144773/time-formula2026-01-20T00:58:30+00:00 https://community.smartsheet.com/discussion/144749/help-with-if2026-01-19T09:35:08+00:00 https://community.smartsheet.com/discussion/144763/formula-counting-and-blank-data2026-01-16T19:14:54+00:00 https://community.smartsheet.com/discussion/144651/contains-to-check-box-if-cell-has-certain-email-domain2026-01-16T18:27:29+00:00 https://community.smartsheet.com/discussion/144748/running-count-for-rows2026-01-16T14:08:49+00:00 https://community.smartsheet.com/discussion/144710/overall-project-health-based-on-health-of-milestones2026-01-16T14:08:58+00:00 https://community.smartsheet.com/discussion/144731/looking-for-hopefully-simple-formula2026-01-15T22:08:02+00:00 https://community.smartsheet.com/discussion/144732/averaging-a-number-column-from-prior-full-weeks2026-01-15T22:08:12+00:00 https://community.smartsheet.com/discussion/144739/smartsheetgov-cross-sheet-reference-token-broken2026-01-15T22:09:44+00:00 https://community.smartsheet.com/discussion/144733/how-can-you-calculate-new-date-off-of-date-fields2026-01-15T22:08:24+00:00 https://community.smartsheet.com/discussion/144694/creating-a-formula-to-calculate-created-date-column-not-working-correctly2026-01-15T16:29:19+00:00 https://community.smartsheet.com/discussion/144598/match-function-to-return-required-digits2026-01-15T16:30:04+00:00 https://community.smartsheet.com/discussion/144703/invalid-date-type2026-01-15T16:34:16+00:00 https://community.smartsheet.com/discussion/144706/dashboard-pulling-week-and-year2026-01-15T09:23:40+00:00 https://community.smartsheet.com/discussion/144691/help-with-cross-sheet-lookup2026-01-14T17:10:13+00:00 https://community.smartsheet.com/discussion/144696/index-match-with-varying-match-criteria2026-01-14T17:13:05+00:00 https://community.smartsheet.com/discussion/144657/complicated-if-statement2026-01-14T17:09:58+00:00 https://community.smartsheet.com/discussion/88766/automate-status-based-on-due-date-and-complete-date2026-01-13T23:41:46+00:00 https://community.smartsheet.com/discussion/144690/i-cannot-seem-to-cross-reference-a-sheet-to-another-sheet-and-im-going-insane2026-01-13T23:42:17+00:00 https://community.smartsheet.com/discussion/144684/cross-sheet-formula-for-averaging-total-turn-around-time2026-01-13T23:43:27+00:00 https://community.smartsheet.com/discussion/144683/counting-distinct-items-in-sheet1-from-sheet22026-01-13T17:53:25+00:00 https://community.smartsheet.com/discussion/144682/help-needed2026-01-13T16:17:09+00:00 https://community.smartsheet.com/discussion/144671/index-formula-to-get-the-text-in-the-next-row-in-a-different-column2026-01-13T16:19:12+00:00 https://community.smartsheet.com/discussion/144607/index-collect-question2026-01-13T08:53:59+00:00 https://community.smartsheet.com/discussion/144672/how-to-remove-duplicate-items-from-drop-down-columns2026-01-13T08:54:22+00:00 https://community.smartsheet.com/discussion/144668/additional-condition-formula2026-01-13T00:57:23+00:00 https://community.smartsheet.com/discussion/144642/calculating-net-hours2026-01-12T12:39:36+00:00 https://community.smartsheet.com/discussion/144652/join-collect-and-contact2026-01-09T20:17:35+00:00 https://community.smartsheet.com/discussion/144647/help-with-sumif-formula2026-01-09T20:16:32+00:00 https://community.smartsheet.com/discussion/144631/multiselect-dashboard-widget-help2026-01-09T19:25:06+00:00 https://community.smartsheet.com/discussion/144556/averageif-function-not-working2026-01-09T18:20:35+00:00 https://community.smartsheet.com/discussion/144628/dynamic-view-predetermined-fields2026-01-09T14:53:35+00:00 https://community.smartsheet.com/discussion/144552/automation-to-increment-number-in-column2026-01-09T14:51:46+00:00 https://community.smartsheet.com/discussion/144621/automations2026-01-08T21:47:23+00:00 https://community.smartsheet.com/discussion/144588/last-step-date-completed2026-01-08T22:03:57+00:00 https://community.smartsheet.com/discussion/144604/invalid-data-type2026-01-08T22:05:13+00:00 https://community.smartsheet.com/discussion/72051/enhancement-request-multiple-rows-from-a-single-form-submission-multiple-lines2026-01-07T20:09:58+00:00 https://community.smartsheet.com/discussion/144601/countif-seems-not-to-work-with-text-containing-leading-zeros2026-01-07T20:11:47+00:00 https://community.smartsheet.com/discussion/130009/how-do-i-show-a-holiday-in-a-date-range2026-01-07T20:12:45+00:00 https://community.smartsheet.com/discussion/144525/supervisor-based-current-user-filtering-in-reports2026-01-07T20:13:05+00:00 https://community.smartsheet.com/discussion/144557/formula-index-match-inconsistencies2026-01-07T09:05:08+00:00 https://community.smartsheet.com/discussion/144572/seeking-automation-for-monthly-dashboard-with-separate-month-rows2026-01-07T09:03:07+00:00 https://community.smartsheet.com/discussion/144549/editing-issues2026-01-07T08:57:07+00:00 https://community.smartsheet.com/discussion/144558/summary-sheet-metric-widget2026-01-06T21:24:13+00:00 https://community.smartsheet.com/discussion/144541/pulling-from-2-different-sheets-into-one-sheet2026-01-06T18:00:34+00:00 https://community.smartsheet.com/discussion/144548/countifs-statement-with-dates-and-other-criteria2026-01-06T16:57:13+00:00 https://community.smartsheet.com/discussion/139694/is-there-a-way-to-maintain-currency-formatting-when-within-a-formula2026-01-06T14:10:50+00:00 https://community.smartsheet.com/discussion/144546/report-malfunction2026-01-06T14:12:15+00:00 https://community.smartsheet.com/discussion/144543/how-to-calculate-the-first-date-of-the-previous-month-including-when-the-year-changes2026-01-06T13:18:10+00:00 https://community.smartsheet.com/discussion/144542/index-match2026-01-06T14:12:57+00:00 https://community.smartsheet.com/discussion/144539/logic-for-parent-row-status2026-01-05T19:26:37+00:00 https://community.smartsheet.com/discussion/144527/countif-no-match2026-01-05T19:27:24+00:00 https://community.smartsheet.com/discussion/144538/using-sum-with-child-rows2026-01-05T09:36:54+00:00 https://community.smartsheet.com/discussion/144521/how-to-link-to-data-in-one-sheet-and-transpose-the-data-in-a-new-shieet2026-01-02T19:44:48+00:00 https://community.smartsheet.com/discussion/144536/date-time-stamp-of-change2026-01-02T15:49:53+00:00 https://community.smartsheet.com/discussion/143818/help-with-auto-numbering-my-projects-that-have-children-and-grandchildren2026-01-02T08:51:24+00:00 https://community.smartsheet.com/discussion/95384/formula-to-sum-data-in-another-sheet-that-meets-a-certain-criteria2026-01-02T08:54:21+00:00 https://community.smartsheet.com/discussion/144528/sumifs-formula-with-1-vertical-and-2-horizontal-criteria-crosssheet-references2026-01-02T08:59:22+00:00 https://community.smartsheet.com/discussion/144490/countifs-formula-to-count-based-on-two-columns2026-01-02T09:01:55+00:00 https://community.smartsheet.com/discussion/144524/cut-off-date2025-12-31T15:59:52+00:00 https://community.smartsheet.com/discussion/144522/create-sequential-ids-based-on-columns-responses2025-12-30T21:07:41+00:00 https://community.smartsheet.com/discussion/144514/return-a-value-from-another-sheet-with-multiple-criteria2025-12-30T15:28:21+00:00 https://community.smartsheet.com/discussion/144496/index-match-with-the-range-on-match-is-multiple-columns2025-12-29T21:47:47+00:00 https://community.smartsheet.com/discussion/104078/check-30-schedules-in-large-portfolio-for-correct-progress-updating2025-12-29T19:50:43+00:00 https://community.smartsheet.com/discussion/144478/formatting-issues-with-index-collect-formula2025-12-29T15:13:22+00:00 https://community.smartsheet.com/discussion/144499/i-am-trying-to-add-the-number-of-passengers-per-month-per-year2025-12-29T12:30:39+00:00 https://community.smartsheet.com/discussion/144305/deactivated-workflow2025-12-29T15:00:28+00:00 https://community.smartsheet.com/discussion/144501/formula-wormhole-count-ifs-distinct-with-multiple-range-requests2025-12-26T18:20:31+00:00 https://community.smartsheet.com/discussion/144493/changes-with-predecessors2025-12-24T15:15:31+00:00 https://community.smartsheet.com/discussion/144443/week-number-year-to-year2025-12-24T15:09:12+00:00 https://community.smartsheet.com/discussion/144479/find-and-replace-menu2025-12-23T17:39:49+00:00 https://community.smartsheet.com/discussion/144460/create-sequential-unique-id-for-certain-rows-as-column-formula2025-12-23T15:47:51+00:00 https://community.smartsheet.com/discussion/144462/sumifs-keeps-returning-02025-12-23T15:47:55+00:00 https://community.smartsheet.com/discussion/144464/finding-unique-dates2025-12-23T15:48:08+00:00 https://community.smartsheet.com/discussion/144244/feedback-needed-on-status-rollup-solution2025-12-22T21:46:33+00:00 https://community.smartsheet.com/discussion/144461/track-duration-in-hrs2025-12-22T21:02:20+00:00 https://community.smartsheet.com/discussion/144454/need-to-add-total-track-the-amount-of-times-a-person-signed-out-equipment-in-365-period-from-today2025-12-22T16:15:21+00:00 https://community.smartsheet.com/discussion/144211/need-help-with-index-collect-formula2025-12-22T16:15:03+00:00 https://community.smartsheet.com/discussion/133380/auto-populate-cell-reference-by-field-names2025-12-22T15:41:53+00:00 https://community.smartsheet.com/discussion/144338/date-logic-for-requests-created-after-business-hours2025-12-22T15:43:27+00:00 https://community.smartsheet.com/discussion/144432/use-sheet-summary-as-cell-reference-for-a-different-sheet2025-12-19T17:48:12+00:00 https://community.smartsheet.com/discussion/144331/displaying-multiple-time-periods-in-gantt-view2025-12-19T17:25:01+00:00 https://community.smartsheet.com/discussion/144419/issues-with-if-formula2025-12-19T14:49:16+00:00 https://community.smartsheet.com/discussion/144421/forms-automation2025-12-18T21:03:10+00:00 https://community.smartsheet.com/discussion/144263/if-formula-not-working-as-intended2025-12-18T21:04:10+00:00 https://community.smartsheet.com/discussion/144418/help-with-a-function-to-collect-data-from-2-different-sheets-based-on-year-date2025-12-18T17:34:55+00:00 https://community.smartsheet.com/discussion/144410/collect-data-based-on-todays-date2025-12-18T16:30:49+00:00 https://community.smartsheet.com/discussion/144374/dashboard-report-issue-report-not-showing-data2025-12-18T15:55:08+00:00 https://community.smartsheet.com/discussion/144406/sumifs-using-dropdown2025-12-18T13:56:34+00:00 https://community.smartsheet.com/discussion/89873/calculating-monthly-revenue2025-12-18T08:40:56+00:00 https://community.smartsheet.com/discussion/144409/if-statement-help2025-12-18T01:34:16+00:00 https://community.smartsheet.com/discussion/144375/have-two-auto-number-or-rank-by-created-date2025-12-18T01:42:22+00:00 https://community.smartsheet.com/discussion/144381/date-format-issued-from-date-formula-not-recognized-as-date-message-date-expected2025-12-18T01:44:50+00:00 https://community.smartsheet.com/discussion/144345/can-i-get-automated-reminders-for-a-30-day-check-in-when-dates-in-my-start-date-column-are-different2025-12-17T15:31:06+00:00 https://community.smartsheet.com/discussion/144380/formula-just-stopped-working2025-12-17T14:57:45+00:00 https://community.smartsheet.com/discussion/144357/date-and-time-separator-formula2025-12-17T14:55:31+00:00 https://community.smartsheet.com/discussion/144370/creating-a-report-frm-several-sheets-to-assign-tasks-without-adding-an-assigned-column-to-each-sheet2025-12-17T08:42:20+00:00 https://community.smartsheet.com/discussion/144372/unique-countif-formula-need-help2025-12-17T08:50:09+00:00 https://community.smartsheet.com/discussion/144259/i-occasionally-get-error-results-from-formulas-that-are-only-fixed-by-a-page-refresh2025-12-16T21:07:19+00:00 https://community.smartsheet.com/discussion/144354/docusign-document2025-12-16T17:11:56+00:00 https://community.smartsheet.com/discussion/144334/formula-to-check-a-box-based-on-criteria2025-12-16T15:17:49+00:00 https://community.smartsheet.com/discussion/144302/formula-index-match-from-two-different-sheets2025-12-16T13:39:38+00:00 https://community.smartsheet.com/discussion/144343/need-help-with-multiple-criteria2025-12-15T22:30:54+00:00 https://community.smartsheet.com/discussion/144326/min-collect-help-date-returning-zero-value2025-12-15T22:31:13+00:00 https://community.smartsheet.com/discussion/144324/distinct-values-from-multiple-sheets2025-12-15T17:04:44+00:00 https://community.smartsheet.com/discussion/144296/returning-matches-in-multi-select-column-for-exact-match-of-value-and-excluding-value-text2025-12-15T16:20:52+00:00 https://community.smartsheet.com/discussion/143760/cross-sheet-counting2025-12-15T09:22:42+00:00 https://community.smartsheet.com/discussion/144328/exporting-smartsheet-formulas2025-12-15T09:57:47+00:00 https://community.smartsheet.com/discussion/106804/auto-lock-a-cell-after-data-is-entered2025-12-12T23:39:04+00:00 https://community.smartsheet.com/discussion/89152/is-there-a-way-to-identify-and-highlight-that-a-particular-contact-has-overlapping-dates2025-12-12T23:40:03+00:00 https://community.smartsheet.com/discussion/144322/symbol-return-formula2025-12-12T21:53:04+00:00 https://community.smartsheet.com/discussion/144277/pulling-original-due-dates-from-updated-due-dates-cell2025-12-12T17:32:41+00:00 https://community.smartsheet.com/discussion/144286/using-automations-for-filtering-a-daily-refreshed-sheet-from-external-doc2025-12-12T16:18:16+00:00 https://community.smartsheet.com/discussion/144306/formula-help2025-12-12T17:33:07+00:00 https://community.smartsheet.com/discussion/144312/nested-if-statement2025-12-12T17:33:39+00:00 https://community.smartsheet.com/discussion/144309/cross-sheet-reference2025-12-12T17:34:20+00:00 https://community.smartsheet.com/discussion/144301/expanding-my-index-to-additional-sheets2025-12-12T08:16:52+00:00 https://community.smartsheet.com/discussion/143158/index-collect-formula-with-checkbox2025-12-11T18:07:42+00:00 https://community.smartsheet.com/discussion/144293/formatting2025-12-11T18:10:40+00:00 https://community.smartsheet.com/discussion/144158/countif-from-8-different-sheets-with-data-criteria2025-12-11T14:52:41+00:00 https://community.smartsheet.com/discussion/144284/timeline-view-conditional-formatting-color-not-updating-in-real-time-and-requires-refresh-of-page2025-12-11T14:08:04+00:00 https://community.smartsheet.com/discussion/143096/substitution-for-count-countif-function2025-12-11T14:01:22+00:00 https://community.smartsheet.com/discussion/144183/how-can-i-get-calendar-view-to-stop-showing-wildly-inaccurate-dates2025-12-10T08:57:08+00:00 https://community.smartsheet.com/discussion/140151/cant-use-the-new-timeline-view-when-leveraging-the-new-columns-link-in-table-view2025-12-09T20:20:11+00:00 https://community.smartsheet.com/discussion/144251/how-to-automate-data-involving-dates-and-sum-totals2025-12-09T16:47:19+00:00 https://community.smartsheet.com/discussion/143402/index-or-match-formulas2025-12-09T16:37:58+00:00 https://community.smartsheet.com/discussion/144229/cant-find-option-to-reference-another-sheet-with-new-ai-enabled-design2025-12-09T15:32:41+00:00 https://community.smartsheet.com/discussion/144240/dropdown-link-to-another-sheet-is-not-working2025-12-09T14:33:29+00:00 https://community.smartsheet.com/discussion/144224/join-accounting2025-12-08T22:49:36+00:00 https://community.smartsheet.com/discussion/144222/child-row-and-multi-contact-cell-selections2025-12-08T18:03:38+00:00 https://community.smartsheet.com/discussion/144213/adding-sequetial-number-string2025-12-08T16:16:08+00:00 https://community.smartsheet.com/discussion/144192/unable-to-count-blank-empty-cells-in-a-column2025-12-08T14:54:31+00:00 https://community.smartsheet.com/discussion/144186/countifs2025-12-08T14:54:52+00:00 https://community.smartsheet.com/discussion/144202/average-with-exceptions2025-12-08T09:29:16+00:00 https://community.smartsheet.com/discussion/144194/trying-to-add-a-year-to-this-formula2025-12-05T16:28:05+00:00 https://community.smartsheet.com/discussion/119036/change-value-in-symbol-column-based-on-value-of-other-column2025-12-05T15:26:44+00:00 https://community.smartsheet.com/discussion/144164/index-match-formula-referencing-other-sheet-works-incorrectly-when-matching-formula-column2025-12-05T13:39:58+00:00 https://community.smartsheet.com/discussion/144178/index-match-collect-failure2025-12-04T21:09:35+00:00 https://community.smartsheet.com/discussion/144182/formula-to-calculate-task-completion-by-owner-by-referencing-parent-rows2025-12-04T21:09:39+00:00 https://community.smartsheet.com/discussion/144143/i-need-an-update-request-to-include-and-item-name-and-quantity-but-only-edit-the-qty2025-12-04T18:51:50+00:00 https://community.smartsheet.com/discussion/144172/recording-words-from-column-b-to-column-a2025-12-04T18:53:35+00:00 https://community.smartsheet.com/discussion/144151/extract-4th-email-address-from-multi-select-cell-with-char-10-as-delimeter2025-12-04T18:49:12+00:00 https://community.smartsheet.com/discussion/144149/combining-sumif-and-and-formulas2025-12-04T16:40:29+00:00 https://community.smartsheet.com/discussion/144162/publish-option-missing-on-grid-sheet-despite-being-system-admin-with-publishing-enabled2025-12-04T16:40:03+00:00 https://community.smartsheet.com/discussion/144152/need-to-figure-out-a-way-or-a-formula2025-12-03T23:02:59+00:00 https://community.smartsheet.com/discussion/98192/disable-auto-update-of-start-dates-for-dependent-tasks2025-12-03T22:03:03+00:00 https://community.smartsheet.com/discussion/144090/last-working-day-of-the-current-month2025-12-03T20:42:30+00:00 https://community.smartsheet.com/discussion/144128/sum-based-on-two-columns-words-and-sum-numbers2025-12-03T20:43:48+00:00 https://community.smartsheet.com/discussion/144082/countif-contains-returns-02025-12-03T16:10:52+00:00 https://community.smartsheet.com/discussion/144099/formula-to-tick-a-box-if-two-conditions-in-another-sheet-are-true2025-12-03T09:12:38+00:00 https://community.smartsheet.com/discussion/144075/how-to-make-a-sum-for-each-day-automatically2025-12-03T08:41:35+00:00 https://community.smartsheet.com/discussion/144126/military-time2025-12-03T09:11:01+00:00 https://community.smartsheet.com/discussion/104349/automate-parent-status-rollup-based-on-descendants-statuses2025-12-03T08:58:06+00:00 https://community.smartsheet.com/discussion/144103/can-i-use-the-formula-countif-to-give-me-the-number-of-hires-by-week2025-12-02T20:35:42+00:00 https://community.smartsheet.com/discussion/143990/update-column-based-on-last-comment2025-12-02T20:35:52+00:00 https://community.smartsheet.com/discussion/144111/last-update-to-look-for-last-manual-update-not-last-formula-update2025-12-02T20:36:07+00:00 https://community.smartsheet.com/discussion/134793/count-the-number-of-entries-in-the-last-7-days2025-12-02T20:36:16+00:00 https://community.smartsheet.com/discussion/144077/calculate-duration-between-two-times2025-12-02T17:45:52+00:00 https://community.smartsheet.com/discussion/144091/basic-formula-im-sure-but-im-new-to-this2025-12-02T17:09:36+00:00 https://community.smartsheet.com/discussion/142357/attachments-not-sending-in-email-alert2025-12-02T16:04:00+00:00 https://community.smartsheet.com/discussion/144101/formula-to-sum-children-rows-into-parent-row2025-12-02T16:09:07+00:00 https://community.smartsheet.com/discussion/144100/need-formula-to-dynamically-populate-multiple-rows-from-cross-sheet-reference2025-12-02T15:13:28+00:00 https://community.smartsheet.com/discussion/144104/help-with-a-formula2025-12-02T15:13:41+00:00 https://community.smartsheet.com/discussion/144092/index-collect-max-without-blank2025-12-02T14:02:04+00:00 https://community.smartsheet.com/discussion/144073/formula-not-working-adding-a-02025-12-02T08:39:50+00:00 https://community.smartsheet.com/discussion/143951/collecting-the-most-recent-submission2025-12-02T08:38:52+00:00 https://community.smartsheet.com/discussion/144076/checking-if-employee-is-active-in-a-certain-month2025-12-01T14:53:36+00:00 https://community.smartsheet.com/discussion/144050/calculate-percentage-based-on-drop-down-response-from-one-cell-and-value-of-another-cell2025-12-01T14:52:53+00:00 https://community.smartsheet.com/discussion/144038/join-collect-from-dropdown2025-11-28T16:10:20+00:00 https://community.smartsheet.com/discussion/144059/date-time-cutoff-tracking2025-11-27T17:21:06+00:00 https://community.smartsheet.com/discussion/144005/update-request-automation-email-does-not-include-custom-instructions2025-11-26T21:13:35+00:00 https://community.smartsheet.com/discussion/144058/moved-move-attachment-based-on-key-data2025-11-26T19:04:43+00:00 https://community.smartsheet.com/discussion/144047/how-to-calculate-the-of-complete-activities-under-each-parent-row2025-11-26T21:17:20+00:00 https://community.smartsheet.com/discussion/144039/contact-list-with-upates2025-11-26T21:23:11+00:00 https://community.smartsheet.com/discussion/144040/formulas-for-sheet-to-sheet-summary-to-dashboard2025-11-26T21:21:11+00:00 https://community.smartsheet.com/discussion/144042/formula-error-multiple-criteria2025-11-26T21:21:31+00:00 https://community.smartsheet.com/discussion/144022/multiplying-the-values-of-my-ancestors2025-11-26T08:43:03+00:00 https://community.smartsheet.com/discussion/130156/formula-to-remove-the-d-from-days-needed-rollup-number-relinked-into-my-summary-sheet2025-11-26T08:55:46+00:00 https://community.smartsheet.com/discussion/144027/how-to-tally-days-with-an-date-entries2025-11-25T19:24:56+00:00 https://community.smartsheet.com/discussion/143330/how-do-i-limit-the-number-of-entries-under-the-same-company-name2025-11-25T19:34:50+00:00 https://community.smartsheet.com/discussion/143999/reconciling-events-and-transactions2025-11-25T19:35:01+00:00 https://community.smartsheet.com/discussion/142993/conditional-formatting2025-11-25T19:39:03+00:00 https://community.smartsheet.com/discussion/144016/using-index-collect-formula-referencing-another-sheet2025-11-25T19:39:10+00:00 https://community.smartsheet.com/discussion/144010/set-column-formula-with-different-formulas-for-parent-and-child-rows2025-11-25T19:39:15+00:00 https://community.smartsheet.com/discussion/143981/intermittent-errors-on-column-formula-report-always-displaying-errors2025-11-25T19:40:03+00:00 https://community.smartsheet.com/discussion/143976/formula-to-pull-in-the-sheetname-to-a-cell2025-11-25T09:08:36+00:00 https://community.smartsheet.com/discussion/143992/range-checking-flags2025-11-25T09:24:11+00:00 https://community.smartsheet.com/discussion/143979/flagging-rows-based-on-number-of-occurrences-within-a-range-of-another-date2025-11-25T09:08:47+00:00 https://community.smartsheet.com/discussion/143984/collect-from-another-sheet2025-11-25T09:22:00+00:00 https://community.smartsheet.com/discussion/143980/trim-leading-trailing-spaces2025-11-24T10:28:27+00:00 https://community.smartsheet.com/discussion/143973/budget-sum-total-of-a-specific-category2025-11-24T09:15:57+00:00 https://community.smartsheet.com/discussion/143961/automation-to-move-cells-without-individual-logic2025-11-21T23:19:26+00:00 https://community.smartsheet.com/discussion/143960/help-with-a-simple-formula2025-11-21T18:12:45+00:00 https://community.smartsheet.com/discussion/143926/sumsif-formula-help2025-11-21T08:17:11+00:00 https://community.smartsheet.com/discussion/143943/getting-error-in-a-countif-formula2025-11-20T21:53:48+00:00 https://community.smartsheet.com/discussion/143939/linking-end-dates-to-another-smartsheet2025-11-20T21:16:37+00:00 https://community.smartsheet.com/discussion/110985/dashboard-last-updated-date2025-11-20T19:28:33+00:00 https://community.smartsheet.com/discussion/143927/index-match-formula-error-no-match-when-there-is-an-exact-match2025-11-20T17:52:07+00:00 https://community.smartsheet.com/discussion/143925/is-there-a-workaround-to-ensure-rows-are-added-to-the-top-of-a-sheet2025-11-20T18:05:26+00:00 https://community.smartsheet.com/discussion/143916/is-it-possible-to-reference-a-cell-or-summary-field-in-a-column-formula2025-11-20T15:13:26+00:00 https://community.smartsheet.com/discussion/143920/formula-on-target-date-column2025-11-20T13:25:00+00:00 https://community.smartsheet.com/discussion/143786/need-a-cell-value-on-each-row2025-11-20T09:22:20+00:00 https://community.smartsheet.com/discussion/143884/min-max-collect-formula-help2025-11-20T01:30:31+00:00 https://community.smartsheet.com/discussion/140238/countifs-for-multiple-listed-characters-not-using-numbers-in-multiple-columns2025-11-20T01:31:16+00:00 https://community.smartsheet.com/discussion/143911/sumif-or-sumifs2025-11-19T19:40:15+00:00 https://community.smartsheet.com/discussion/143908/countif-formuls2025-11-19T17:28:55+00:00 https://community.smartsheet.com/discussion/143901/how-to-show-risk-register-trends-on-a-dashboard-graph2025-11-19T15:25:09+00:00 https://community.smartsheet.com/discussion/143869/countif-problem2025-11-19T09:25:08+00:00 https://community.smartsheet.com/discussion/143870/autopopulate-the-percentage-complete-based-purely-on-the-time-passed2025-11-18T15:57:31+00:00 https://community.smartsheet.com/discussion/143875/i-created-a-date-column-to-generates-dates-by-adding-few-fields-but-i-am-getting-an-invalidoperation2025-11-18T21:47:42+00:00 https://community.smartsheet.com/discussion/143755/calculate-days-past-due-and-or-days-to-complete2025-11-18T08:34:28+00:00 https://community.smartsheet.com/discussion/143824/formula-error-incorrect-argument-set2025-11-18T00:06:58+00:00 https://community.smartsheet.com/discussion/143863/updating-health-formula-to-include-blue-status-for-completed-tasks2025-11-18T00:07:40+00:00 https://community.smartsheet.com/discussion/143858/cross-sheet-countifs-w-checkbox2025-11-18T00:08:09+00:00 https://community.smartsheet.com/discussion/143855/drop-down-list2025-11-17T20:10:48+00:00 https://community.smartsheet.com/discussion/143856/countif-a-cell-is-notblank2025-11-17T20:11:10+00:00 https://community.smartsheet.com/discussion/143847/trying-to-calculate-total-savings-budget-actual-when-column-b-contains-both-numbers-and-text2025-11-17T14:00:23+00:00 https://community.smartsheet.com/discussion/143840/average-duration-formula2025-11-17T13:58:44+00:00 https://community.smartsheet.com/discussion/143849/is-there-any-automation-workflow-which-saves-the-sheet-after-the-trigger2025-11-17T14:00:32+00:00 https://community.smartsheet.com/discussion/143821/if-and-formula2025-11-17T13:58:25+00:00 https://community.smartsheet.com/discussion/143812/burndown-chart2025-11-17T13:58:09+00:00 https://community.smartsheet.com/discussion/143822/identifying-a-risk-in-my-project-plan2025-11-14T17:36:25+00:00 https://community.smartsheet.com/discussion/97426/sheet-folder-template2025-11-14T09:13:10+00:00 https://community.smartsheet.com/discussion/74485/how-to-dynamically-populate-a-dropdown-box2025-11-14T08:56:50+00:00 https://community.smartsheet.com/discussion/143690/index-collect2025-11-14T09:16:33+00:00 https://community.smartsheet.com/discussion/99750/how-do-i-dynamically-update-a-dropdown-list2025-11-14T08:58:53+00:00 https://community.smartsheet.com/discussion/106406/formula-as-alternative-to-dynamic-dropdown-menus2025-11-14T09:00:01+00:00 https://community.smartsheet.com/discussion/143102/dynamic-dropdown-lists-driven-by-formulas2025-11-14T09:00:43+00:00 https://community.smartsheet.com/discussion/143707/automatically-add-child-sum-to-rows2025-11-14T09:17:38+00:00 https://community.smartsheet.com/discussion/143808/today-formula-constantly-changing-date-to-current-date2025-11-14T09:31:01+00:00 https://community.smartsheet.com/discussion/143809/formula-with-date-column-weirdness2025-11-14T09:31:50+00:00 https://community.smartsheet.com/discussion/143674/if-contains-formula2025-11-14T09:15:57+00:00 https://community.smartsheet.com/discussion/111330/limit-on-workflows-triggering-other-workflows-aka-daisy-chained-autoamtions2025-11-13T20:19:16+00:00 https://community.smartsheet.com/discussion/143783/this-formula-is-working-for-other-number-ranges-but-not-this-one2025-11-13T20:21:15+00:00 https://community.smartsheet.com/discussion/143800/merged-if-contains-formula2025-11-13T17:37:57+00:00 https://community.smartsheet.com/discussion/143773/best-practices-for-overall-schedule-deviation2025-11-13T17:30:56+00:00 https://community.smartsheet.com/discussion/143795/can-i-reference-another-sheet-in-table-view2025-11-13T15:32:30+00:00 https://community.smartsheet.com/discussion/143793/operations-intake-portfolio-capacity-management2025-11-13T15:21:07+00:00 https://community.smartsheet.com/discussion/143784/moved-can-i-view-sheet-level-comments-on-a-report2025-11-12T21:19:35+00:00 https://community.smartsheet.com/discussion/143772/formula-to-extract-and-sum-cells-from-drop-down2025-11-12T22:59:05+00:00 https://community.smartsheet.com/discussion/143763/need-a-column-formula-that-pulls-from-the-parent-row2025-11-12T23:06:37+00:00 https://community.smartsheet.com/discussion/143749/why-does-my-stacked-bar-show-1202025-11-12T23:07:42+00:00 https://community.smartsheet.com/discussion/143747/return-value-from-list2025-11-12T23:08:30+00:00 https://community.smartsheet.com/discussion/143716/unable-to-manage-scheduled-report-recurrence-options-disabled2025-11-12T23:13:27+00:00 https://community.smartsheet.com/discussion/143728/how-to-find-hours-in-any-period2025-11-12T09:43:55+00:00 https://community.smartsheet.com/discussion/75069/conditional-dropdown-list2025-11-12T09:26:48+00:00 https://community.smartsheet.com/discussion/143662/index-collect-formula-assistance2025-11-12T09:40:42+00:00 https://community.smartsheet.com/discussion/143731/best-way-to-populate-multiple-invoice-s-in-a-single-cell2025-11-11T15:22:43+00:00 https://community.smartsheet.com/discussion/143611/index-collect-over-multiple-documents2025-11-11T14:10:27+00:00 https://community.smartsheet.com/discussion/143732/which-formula-can-be-used-to-extract-the-values-with-in-bracket-in-a-multi-value-cell2025-11-11T13:50:22+00:00 https://community.smartsheet.com/discussion/143709/column-linking-not-working-what-am-i-missing2025-11-10T20:54:54+00:00 https://community.smartsheet.com/discussion/143704/when-predecessor-completes-mark-next-task-to-in-progress2025-11-10T17:06:00+00:00 https://community.smartsheet.com/discussion/143705/trying-to-compare-cells-to-update-dates2025-11-10T17:06:12+00:00 https://community.smartsheet.com/discussion/143678/formula-to-calculate-of-projects-per-month2025-11-10T16:33:57+00:00 https://community.smartsheet.com/discussion/143695/counting-cells-with-two-rules2025-11-10T16:34:08+00:00 https://community.smartsheet.com/discussion/143684/how-to-populate-valid-resource-rates-from-a-source-table-for-each-week-of-a-project2025-11-10T16:34:22+00:00 https://community.smartsheet.com/discussion/142066/how-to-get-total-count-for-projects-releasing-now-through-the-next-3-months2025-11-10T15:26:25+00:00 https://community.smartsheet.com/discussion/143601/which-is-the-right-formula-to-join-the-text-in-multiple-cells2025-11-10T15:26:44+00:00 https://community.smartsheet.com/discussion/143670/add-values-to-each-dropdown-value2025-11-10T15:27:04+00:00 https://community.smartsheet.com/discussion/143559/based-on-frequency-selected-change-the-formula-for-the-created-date2025-11-10T12:03:21+00:00 https://community.smartsheet.com/discussion/143635/need-help-with-index-formula-across-sheets2025-11-10T08:40:25+00:00 https://community.smartsheet.com/discussion/143685/contains-formula-within-a-date-range2025-11-10T09:28:09+00:00 https://community.smartsheet.com/discussion/143608/help-to-link-health-status-formula-to-status2025-11-10T09:09:20+00:00 https://community.smartsheet.com/discussion/143701/projects-releasing-today-60-days2025-11-10T09:32:19+00:00 https://community.smartsheet.com/discussion/143600/report-for-past-due-tasks2025-11-10T09:03:59+00:00 https://community.smartsheet.com/discussion/143644/date-automation2025-11-07T22:10:10+00:00 https://community.smartsheet.com/discussion/143681/multiselect-dropdown-formula-for-multiple-combinations2025-11-07T20:13:03+00:00 https://community.smartsheet.com/discussion/143686/collect-cross-sheet-formula-help2025-11-07T15:22:10+00:00 https://community.smartsheet.com/discussion/143619/adding-cells-with-iferror-blanks2025-11-07T09:15:54+00:00 https://community.smartsheet.com/discussion/143671/creating-a-gift-card-inventory-and-transaction-log2025-11-07T01:32:59+00:00 https://community.smartsheet.com/discussion/143653/created-date-by-column-to-show-on-line-entries-only2025-11-06T20:02:12+00:00 https://community.smartsheet.com/discussion/143630/formula-check-select-drop-down-option-based-on-other-columns2025-11-06T17:53:41+00:00 https://community.smartsheet.com/discussion/143614/merge-date-and-time-then-calculate-hrs-remaining2025-11-06T17:53:20+00:00 https://community.smartsheet.com/discussion/81191/separate-predecessors-for-start-and-end-dates2025-11-06T16:25:52+00:00 https://community.smartsheet.com/discussion/143648/help-on-getting-the-shift-from-a-time2025-11-06T16:19:56+00:00 https://community.smartsheet.com/discussion/143509/getting-unparseable-error-on-nested-if-and-or-formula-with-cross-sheet-references2025-11-06T15:35:30+00:00 https://community.smartsheet.com/discussion/143604/question-for-countif-function2025-11-06T02:35:41+00:00 https://community.smartsheet.com/discussion/116336/sequence-numbering-based-on-another-cells-info2025-11-05T21:53:37+00:00 https://community.smartsheet.com/discussion/143589/problems-automating-and-matching-with-formula2025-11-05T21:54:16+00:00 https://community.smartsheet.com/discussion/135927/checking-a-column-for-a-single-cell-that-meets-all-conditions2025-11-05T21:54:02+00:00 https://community.smartsheet.com/discussion/143616/sum-cells-from-a-reference-sheet-based-on-a-range-of-dates2025-11-05T21:54:28+00:00 https://community.smartsheet.com/discussion/143581/assistance-with-if-and-or-statements2025-11-04T19:51:08+00:00 https://community.smartsheet.com/discussion/143577/target-start-end-date2025-11-04T19:51:17+00:00 https://community.smartsheet.com/discussion/143584/performing-an-audit-best-practice2025-11-04T19:21:31+00:00 https://community.smartsheet.com/discussion/143465/need-a-formula-that-returns-a-date-while-factoring-in-dependencies2025-11-04T15:32:00+00:00 https://community.smartsheet.com/discussion/143237/row-id-row-link2025-11-04T14:16:38+00:00 https://community.smartsheet.com/discussion/140548/formula-to-calculate-a-future-date-on-a-specific-day-monthly-and-quarterly2025-11-04T06:25:30+00:00 https://community.smartsheet.com/discussion/143534/have-i-stumped-smartsheet-ai-on-calculating-dates2025-11-04T01:46:05+00:00 https://community.smartsheet.com/discussion/143565/counting-tasks-completed-on-time2025-11-04T01:47:17+00:00 https://community.smartsheet.com/discussion/143508/ways-to-avoid-25000000-formula-cell-reference-limit2025-11-03T19:22:59+00:00 https://community.smartsheet.com/discussion/143547/have-header-row-sum-all-items-within-same-column2025-11-03T19:23:54+00:00 https://community.smartsheet.com/discussion/143555/summary-sheet-values-dont-update-in-dashboard-without-entering-source-sheet2025-11-03T19:24:17+00:00 https://community.smartsheet.com/discussion/119965/why-do-i-get-invalid-value2025-11-03T16:38:30+00:00 https://community.smartsheet.com/discussion/143403/pull-date-from-text-string-for-conditional-formatting2025-11-03T14:46:36+00:00 https://community.smartsheet.com/discussion/143422/multiple-criteria-for-index-match-or-collect2025-11-03T14:33:10+00:00 https://community.smartsheet.com/discussion/135502/how-do-you-add-a-recurring-monthly-task-to-a-sheet2025-11-03T10:46:19+00:00 https://community.smartsheet.com/discussion/56541/automatocally-changing-due-dates-and-status-on-recurring-tasks-monthly-weekly-etc2025-11-03T10:46:18+00:00 https://community.smartsheet.com/discussion/143526/if-and-and-for-driving-progress-bar-symbol2025-10-31T22:35:26+00:00 https://community.smartsheet.com/discussion/143522/multiple-emails-in-contact-list2025-10-31T22:43:44+00:00 https://community.smartsheet.com/discussion/143392/project-schedule-question2025-10-31T14:37:23+00:00 https://community.smartsheet.com/discussion/143511/help-with-sumifs2025-10-31T14:35:41+00:00 https://community.smartsheet.com/discussion/143481/extracting-emails-from-a-mixed-contacts-column2025-10-31T08:12:47+00:00 https://community.smartsheet.com/discussion/143486/formula-help-extracting-month-only-from-formula-driven-column2025-10-30T20:55:54+00:00 https://community.smartsheet.com/discussion/67424/formula-to-only-count-unique-cells-no-duplicates2025-10-30T20:58:08+00:00 https://community.smartsheet.com/discussion/143424/overdue-is-not-working-when-today-date-is-greater-than-overdue2025-10-30T21:00:41+00:00 https://community.smartsheet.com/discussion/143488/sum-match-formula2025-10-30T21:03:54+00:00 https://community.smartsheet.com/discussion/143484/converting-days-to-months2025-10-30T21:04:39+00:00 https://community.smartsheet.com/discussion/103774/problem-with-formulas-module-self-paced-learning2025-10-30T13:10:16+00:00 https://community.smartsheet.com/discussion/143397/nested2025-10-30T13:50:57+00:00 https://community.smartsheet.com/discussion/143470/formula-for-sumif-all-orders-within-last-90-days2025-10-30T13:51:31+00:00 https://community.smartsheet.com/discussion/143462/parent-children-row-date-automation2025-10-30T13:51:39+00:00 https://community.smartsheet.com/discussion/143472/microsoft-causing-issues2025-10-30T12:10:51+00:00 https://community.smartsheet.com/discussion/133237/systems-and-services-subscription-renewal-dates2025-10-29T19:52:56+00:00 https://community.smartsheet.com/discussion/106287/automated-update-after-an-automated-report-has-already-sent2025-10-29T19:49:09+00:00 https://community.smartsheet.com/discussion/143445/creating-a-formula-that-takes-the-total-average-of-a-row-but-excludes-certain-entries2025-10-29T17:28:27+00:00 https://community.smartsheet.com/discussion/143452/help-with-index-match-across-multiple-columns-with-criteria2025-10-29T15:04:07+00:00 https://community.smartsheet.com/discussion/143414/using-if-index-match2025-10-29T15:04:29+00:00 https://community.smartsheet.com/discussion/143433/dynamic-formula-to-update-a-cell-with-a-url-display-text2025-10-29T13:20:02+00:00 https://community.smartsheet.com/discussion/143404/nonparseable-error-using-iferror2025-10-29T13:16:48+00:00 https://community.smartsheet.com/discussion/143399/formula-for-month-in-words2025-10-29T13:19:06+00:00 https://community.smartsheet.com/discussion/143434/referencing-a-sheet-that-has-non-working-days2025-10-29T13:19:27+00:00 https://community.smartsheet.com/discussion/143365/mastersheet-linking-errors-after-adding-column-unparseable-incorrect-argument-blocking2025-10-29T08:39:46+00:00 https://community.smartsheet.com/discussion/143370/countif-with-contains2025-10-28T21:38:32+00:00 https://community.smartsheet.com/discussion/143407/combined-report-of-sheet-names2025-10-28T21:42:35+00:00 https://community.smartsheet.com/discussion/143415/is-it-possible-to-index-match-a-cell-with-multiple-contacts-from-another-sheet2025-10-28T17:19:13+00:00 https://community.smartsheet.com/discussion/143412/locked-column-changing-to-date-column-type2025-10-28T17:22:30+00:00 https://community.smartsheet.com/discussion/143394/does-field-substitution-work-in-change-cell-value2025-10-28T15:31:20+00:00 https://community.smartsheet.com/discussion/143393/indexing-the-entire-column-from-another-sheet2025-10-28T15:31:06+00:00 https://community.smartsheet.com/discussion/143321/index-match-primary-sheet-to-individual-sheet2025-10-27T23:23:41+00:00 https://community.smartsheet.com/discussion/105269/exporting-a-report-into-excel-with-formatting2025-10-28T08:14:52+00:00 https://community.smartsheet.com/discussion/66834/log-function2025-10-27T21:12:27+00:00 https://community.smartsheet.com/discussion/143389/no-match-on-a-column-with-a-formula2025-10-27T21:13:42+00:00 https://community.smartsheet.com/discussion/42701/formula-to-retrieve-most-frequent-number2025-10-27T20:03:59+00:00 https://community.smartsheet.com/discussion/143376/easiest-way-to-vlookup-off-a-file2025-10-27T20:16:32+00:00 https://community.smartsheet.com/discussion/103657/countifs-formula-with-and-or-criteria-across-multiple-columns2025-10-27T20:05:44+00:00 https://community.smartsheet.com/discussion/143383/how-do-i-include-field-changes-in-an-email-automation-question2025-10-27T20:17:14+00:00 https://community.smartsheet.com/discussion/71996/export-with-formulas-intact2025-10-27T20:04:13+00:00 https://community.smartsheet.com/discussion/143348/outo-populate-a-field-on-a-form-when-the-form-is-being-fill-out2025-10-27T20:13:53+00:00 https://community.smartsheet.com/discussion/143353/help-for-index-collect-with-multiple-criteria2025-10-27T20:14:06+00:00 https://community.smartsheet.com/discussion/143219/countifs2025-10-27T20:07:35+00:00 https://community.smartsheet.com/discussion/143299/sumifs-formula-application-questions2025-10-27T20:08:30+00:00 https://community.smartsheet.com/discussion/84710/countsifs-does-not-contain2025-10-27T20:04:39+00:00 https://community.smartsheet.com/discussion/143342/need-help-with-an-index-match-using-text-for-dates2025-10-27T20:12:13+00:00 https://community.smartsheet.com/discussion/143324/iferror-using-multiple-sheets2025-10-27T20:10:14+00:00 https://community.smartsheet.com/discussion/143356/rbg-and-gray-formula2025-10-27T10:21:13+00:00 https://community.smartsheet.com/discussion/143328/rolling-and-automated-inventory2025-10-25T00:24:58+00:00 https://community.smartsheet.com/discussion/143352/how-to-count-if-checkbox-is-checked2025-10-24T20:27:57+00:00 https://community.smartsheet.com/discussion/143345/creating-charts-from-checkboxes2025-10-24T19:36:19+00:00 https://community.smartsheet.com/discussion/112649/solution-for-extreme-amount-of-conditional-formattting2025-10-24T20:17:45+00:00 https://community.smartsheet.com/discussion/143343/max-collect-formula-for-dates-in-1-row2025-10-24T19:35:32+00:00 https://community.smartsheet.com/discussion/79073/error-formulas-reference-too-many-cells2025-10-24T08:19:05+00:00 https://community.smartsheet.com/discussion/75838/formula-to-change-date-from-existing-date-column-to-the-current-year2025-10-23T23:01:33+00:00 https://community.smartsheet.com/discussion/143088/ideas-workarounds-for-how-to-look-up-multiple-values-into-multiple-rows2025-10-23T19:20:04+00:00 https://community.smartsheet.com/discussion/143310/list-of-u-s-federal-holidays-in-mm-dd-yy-format2025-10-23T19:20:43+00:00 https://community.smartsheet.com/discussion/143276/my-entire-sheet-is-showing-invalid-argument-set2025-10-23T19:25:48+00:00 https://community.smartsheet.com/discussion/143199/index-collect-min-again2025-10-23T15:55:26+00:00 https://community.smartsheet.com/discussion/143287/perpetual-dates2025-10-23T15:56:48+00:00 https://community.smartsheet.com/discussion/143300/average-collect-formula2025-10-23T15:57:31+00:00 https://community.smartsheet.com/discussion/142937/sumifs-formula-shows-wrong-value2025-10-23T15:54:15+00:00 https://community.smartsheet.com/discussion/143242/broken-formula-linking-cells-from-one-ss-to-another-help2025-10-22T21:04:39+00:00 https://community.smartsheet.com/discussion/143277/conditional-formatting-for-a-due-date-that-is-6-months-or-older2025-10-22T20:48:29+00:00 https://community.smartsheet.com/discussion/143282/need-help-with-if-statement-that-will-return2025-10-22T20:50:12+00:00 https://community.smartsheet.com/discussion/143272/extracting-a-date-from-string-of-text2025-10-22T20:56:33+00:00 https://community.smartsheet.com/discussion/143266/vlookup2025-10-22T21:01:58+00:00 https://community.smartsheet.com/discussion/143258/reminder-date-column2025-10-22T21:02:03+00:00 https://community.smartsheet.com/discussion/143197/sort-a-join-collect-formula2025-10-22T14:59:08+00:00 https://community.smartsheet.com/discussion/143257/troubleshooting-sheet-summary-invalid-data-type2025-10-21T21:29:14+00:00 https://community.smartsheet.com/discussion/143255/sum-calculation2025-10-21T19:59:03+00:00 https://community.smartsheet.com/discussion/143254/1-or-more-months-automatic-fill-into-different-columns2025-10-21T19:58:43+00:00 https://community.smartsheet.com/discussion/143249/why-are-my-durations-not-calculating-correctly-and-how-can-i-adjust-this2025-10-21T17:50:06+00:00 https://community.smartsheet.com/discussion/143243/is-store-present-in-list2025-10-21T14:48:08+00:00 https://community.smartsheet.com/discussion/130517/how-do-add-columns-in-smartsheets-dynamically-based-on-a-condition2025-10-21T14:28:51+00:00 https://community.smartsheet.com/discussion/110557/quickly-add-columns-for-dates2025-10-21T14:33:23+00:00 https://community.smartsheet.com/discussion/143204/fy-q1-q2-q3-q42025-10-20T20:19:14+00:00 https://community.smartsheet.com/discussion/143205/referencing-another-sheet-to-have-automated-assigning-of-files2025-10-20T16:11:57+00:00 https://community.smartsheet.com/discussion/143198/how-do-i-check-an-entire-column-for-a-particular-value-and-only-display-the-lowest-example-of-it2025-10-20T16:09:10+00:00 https://community.smartsheet.com/discussion/143179/modified-date-in-formulas2025-10-20T16:10:35+00:00 https://community.smartsheet.com/discussion/143200/has-function-help2025-10-20T09:02:21+00:00 https://community.smartsheet.com/discussion/74972/can-you-copy-export-workflows-conditional-formatting-and-saved-filters-to-other-worksheet2025-10-20T08:53:52+00:00 https://community.smartsheet.com/discussion/143195/index-and-match-formula-with-if-statements2025-10-17T20:52:30+00:00 https://community.smartsheet.com/discussion/143178/un-join-numbers-in-a-cell2025-10-17T17:03:05+00:00 https://community.smartsheet.com/discussion/143186/lookup-formula-not-working2025-10-17T17:05:38+00:00 https://community.smartsheet.com/discussion/143176/formula-help2025-10-17T17:02:41+00:00 https://community.smartsheet.com/discussion/143180/divide-by-and-want-a-max-of-1002025-10-17T07:37:54+00:00 https://community.smartsheet.com/discussion/142389/auto-populate-10-rows-with-todays-date-each-day2025-10-17T07:36:20+00:00 https://community.smartsheet.com/discussion/143163/contact-type-column-automatically-populating-with-email2025-10-16T20:49:26+00:00 https://community.smartsheet.com/discussion/143170/vlookup-returns-nothing-for-assigned-to-requiring-multiple-answers2025-10-16T20:49:50+00:00 https://community.smartsheet.com/discussion/143148/countifs-formula-that-counts-multiple-columns-each-with-multiple-values-in-each-cell2025-10-16T15:34:23+00:00 https://community.smartsheet.com/discussion/142920/sheet-summary-formula-help2025-10-16T14:29:36+00:00 https://community.smartsheet.com/discussion/143085/error-when-referencing-another-sheet2025-10-16T14:30:06+00:00 https://community.smartsheet.com/discussion/143104/a-unique-number-based-of-off-criteria2025-10-16T14:30:54+00:00 https://community.smartsheet.com/discussion/143147/date-formula2025-10-15T22:06:40+00:00 https://community.smartsheet.com/discussion/143151/formula-to-extract-month-name-from-a-cross-sheet2025-10-15T22:07:15+00:00 https://community.smartsheet.com/discussion/143150/question-about-formula-in-smartsheet-template2025-10-15T22:07:08+00:00 https://community.smartsheet.com/discussion/142381/convert-column-to-formula-error2025-10-15T22:00:49+00:00 https://community.smartsheet.com/discussion/86740/return-the-column-name-and-value-for-max-in-a-row2025-10-15T22:00:25+00:00 https://community.smartsheet.com/discussion/123520/how-do-i-set-up-a-workflow-to-notify-someone-if-a-predecessor-task-has-been-completed2025-10-15T22:00:35+00:00 https://community.smartsheet.com/discussion/143138/dynamically-change-rows-based-on-dropdown2025-10-15T13:08:41+00:00 https://community.smartsheet.com/discussion/143139/how-to-sum-a-total-excluding-numbers-before-a-02025-10-15T08:28:43+00:00 https://community.smartsheet.com/discussion/143057/cell-value-for-main-or-subworkflows2025-10-15T08:21:02+00:00 https://community.smartsheet.com/discussion/143114/filters-and-formatting-not-working2025-10-14T20:37:03+00:00 https://community.smartsheet.com/discussion/143115/conditional-formatting-disappears-when-i-begin-to-work-in-a-sheet2025-10-14T20:36:27+00:00 https://community.smartsheet.com/discussion/143126/need-local-time-based-on-city-state2025-10-15T08:25:05+00:00 https://community.smartsheet.com/discussion/143127/need-a-solution-for-parsing-a-value-within-a-block-of-text2025-10-15T08:26:16+00:00 https://community.smartsheet.com/discussion/143100/task-status-update-based-on-previous-step-completion2025-10-14T20:33:20+00:00 https://community.smartsheet.com/discussion/142939/combining-a-few-columns-into-one-can-i-nest-if-statements2025-10-14T15:50:14+00:00 https://community.smartsheet.com/discussion/143108/blocked-formula2025-10-14T15:10:20+00:00 https://community.smartsheet.com/discussion/143089/quoting-tool2025-10-14T15:10:38+00:00 https://community.smartsheet.com/discussion/143097/large-formula-question2025-10-14T15:11:03+00:00 https://community.smartsheet.com/discussion/143101/date-and-time-issue-calendly-zapier-smartsheet2025-10-14T08:12:35+00:00 https://community.smartsheet.com/discussion/143083/today-function-not-auto-updating-unless-sheet-is-opened-and-saved2025-10-14T07:32:04+00:00 https://community.smartsheet.com/discussion/143067/how-to-disable-popups-that-obscure-my-formula2025-10-14T08:05:20+00:00 https://community.smartsheet.com/discussion/143044/help-with-sheet-summary-formula2025-10-14T08:02:38+00:00 https://community.smartsheet.com/discussion/143095/combining-2-if-or-statements2025-10-13T19:50:05+00:00 https://community.smartsheet.com/discussion/143082/work-around-for-year-transitions-when-using-the-weeknumber-formula2025-10-13T15:14:10+00:00 https://community.smartsheet.com/discussion/143054/stumped-with-formula-generated-through-ai-helper2025-10-13T15:13:23+00:00 https://community.smartsheet.com/discussion/121494/looking-for-more-efficient-formula-for-calculating-weeks2025-10-13T07:59:54+00:00 https://community.smartsheet.com/discussion/143016/in-smartsheet-how-do-i-lookup-and-return-different-values-from-sheet-1-to-sheet-2-in-one-cell2025-10-10T21:06:04+00:00 https://community.smartsheet.com/discussion/143068/returning-multiple-results-for-a-cell-with-multiple-values2025-10-10T21:06:23+00:00 https://community.smartsheet.com/discussion/143061/multiple-conditions-for-counting2025-10-10T21:13:23+00:00 https://community.smartsheet.com/discussion/143060/editing-sheet-summary-cy-current-year-so-my-formulas-update2025-10-10T21:13:44+00:00 https://community.smartsheet.com/discussion/89475/time-zone-changing-when-forms-submitted2025-10-10T16:13:19+00:00 https://community.smartsheet.com/discussion/143025/finding-next-closest-date-of-children2025-10-10T16:13:53+00:00 https://community.smartsheet.com/discussion/143024/if-and-or-not-working-properly-last-if-not-triggering-anything2025-10-10T07:35:04+00:00 https://community.smartsheet.com/discussion/143020/sending-an-alert-if-any-one-of-multiple-columns-changes-after-a-deadline-date2025-10-10T07:35:38+00:00