-
Duration and Date closed columns auto populate when Date initiated column is filled in
I have "Date Initiated", "Date Closed" and "Turnover Time" columns. The initiated and closed columns will (should) be populated when they happen, but the closed column auto populates to the same date as the date initiated column when it gets filled in. I also had to create a "Predecessor" column which I hid because I don't…
-
Need a space saving IF OR formula
I have a working function to assign a school county to a new entry when a certain institution ID is put into the column. My issue, however, is the complete equation to accomplish this is too long and doesn't fit the last few school districts. I'm checking to see if there is a more elegant way to accomplish this so I can…
-
Formatting Column to Display Certain Number of Digits
Hi all! Happy New Year :) Hoping for some help with formatting numbers… For context: Employee ID #s at my company are all 8 digits, so if someone's ID # is 123456, we add leading 0s to the front so it would be "00123456" making all Employee ID #s 8-digits. QUESTION: Is there a format-feature or formula I can use to adjust…
-
How can I update data in one sheet from another sheet?
I have a New Hire Master sheet to keep track of our New Hire's onboarding tasks. The first eight columns contain data that needs to be pulled from the New Hire Master Sheet over to the Membership Tracker sheet. I'd like to use a formula to update the the 8 columns in the Membership Tracker with the latest data that is…
-
Column Formula to populate a Helper Column
EDIT: I just realized this is listed in the Add Ons and Integrations section rather than elsewhere, but I cannot move it. I have created separate helper columns to return the value in [Plan Start Helper] for any of the matching [Opp #] where [Plan] contains the word "Plan" (I have other helper columns that need to search…
-
Formula to calculate an average using 12 most recent form submissions that meet certain criteria
Hello Community! I have a database where 11 different units submit data on a monthly basis related to filled FTEs vs. open FTEs so we can determine the monthly vacancy data. I have built out a form that the managers from each unit use each month to submit their filled FTEs for the previous month. Smartsheet then uses…
-
Formula help please! What formula to mark the parent row "Complete" with an "Not Applicable" task?
In my status column I am using this formula auto update my my parent row: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(), "Not Started") > 0, "In…
-
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
-
Column Formula Help - Helper Checkbox for Shift Entries
Hello Community, I am looking for some help with a helper column checkbox formula needed to support reporting of data to a dashboard and downstream formulas. I have four shifts (A,B,C,D) entering data points into a sheet, with the potential for multiple line entries occurring per shift per day worked (see example below). I…
-
How can I enter data in a field that has a column formula?
I have a Contact list as a column type on sheet A and it is attached to my feeder sheet B. Sheet A also has a form attached to it and when a list option is selected, the contact list is populated on the sheet. However, if the list option is not selected, then the contact list does not populate. I need to be able to fill in…
