-
Newbie Question - Need new sheet column to reflect what is on another sheet
Hi all! I'm new to Smartsheets and am struggling through learning how forumulas work still :-) I need column A in "Sheet 2" to reflect the value of column A on "Sheet 1" in the same row. So for example if row 1 on "Sheet 1" is 'Apple' then I want column A on "Sheet 2" row 1 to also say 'Apple'. I've done some searching and…
-
Logic Help
I am trying to come up with a formula that will change my "Has been billed" column to Yes or No based on the dropdown choices in one column and the created date, I am having trouble coming up with some logic that can work around the year with sporatic billing periods. Here is my current formula: I either have remnants from…
-
Linking Columns Across Multiple Forms
Hi! I want to link two columns (Pre-Assessment and Post-Assessment) from my Learner Management Tracking List to my Leaner Data Jan - Dec 2026 sheet. I know who to do the formula. My concern is that the Learner Management Tracking List is live data and we create a new data sheet every year. In 2027, would we just edit…
-
Formula to Indicate Current Month in 90-Day Grace Period for 26 Certifications
I have a sheet that list people on a team in rows with columns containing 26 certification types. Each certification type has a certification date that is also the start date of a 90-day grace period. I have included an end date field for the grace period and a checkbox field to indicate if the person in the grace period…
-
NETWORKDAYS
I'm dying over here! I have tried this formula countless times and #unparesable keeps populating. I am trying to calculate thew amount of days between 2 dates. My column name is Date and Date Complete. I created another Column titled Days to Complete. This is my formula. NETWORKDAYS([Date], [Date Complete], [holidays])…
-
Simplifying Index / Match function
Hi Community! My goal is to have a formula that indexes the "Status" column in my 2.0 WMTN sheet; i have built this formula however the below is only referencing 1 of 5 sheets, so i will need to recreate all the IF functions 5 times over…this isn't very efficient and there's a chance a new task can be added, which then…
-
Text to Number Issue
So the below formula however its resulting in a text result, i.e. left aligned. I'm then trying to run an AVG/Collect or AverageIF formula on this column however its providing a #DIVIDE BY ZERO result. Any idea/thoughts on how to resolve this? Below is the formula resulting in a 'text' result that I cant run a count/avg…
-
Dynamic View filter
I am revising a column in my source sheet. It has a dropdown window where I am adding more keywords. However, when I go to the dynamic view filters to search, the newly added keywords do not appear. Is there a limit as to how many items will show in a dynamic view filter dropdown menu?
-
How to Filter on Blank Cells in a Multi-select Contact List Column
We have a ticketing system that has an assigned column that is a multi-select contact list column type. Before I switched it to multi-select I had a filter that showed the current user and any rows where the assigned column is blank. When I switched to multi-select the blank filter stopped working. I tried a helper column…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…