-
Copy column on one sheet to another column on another sheet (and update when new rows added)
Is there a way in Smartsheet to have Column A in sheet 1 automatically copied/linked over to Column A in sheet 2? We need consistent building names across 12 different sheets, but we want Sheet 1 to be the only place new building names are added. Is this possible?
-
How do I score out a survey and have it populate in another column?
Hi everyone , I am attempting to create a scoring system for a survey based on this type of scoring below. These are the survey questions and it already built in a sheet. Thanks in advance for the support.
-
Compare submissions
Hello! I would like to compare submission such that older submissions from same field "Name" are moved to different sheet. I can add a helper column called "Older" and would like to either populate the older rows with the word "Older," and number to signify it is older, or a simple yes/no dropdown. I currently have a…
-
Sheet Summary - same sheet VLOOKUP with TODAY()
Hi, My Column Headers are: Date, Total Opened Cases, Total Closed Cases, Total Backlog. I am attempting, and failing, to use the following variations of a VLOOKUP formula. Can someone help?? =VLOOKUP(TODAY(), {Date}:{Total Backlog}, 4, false) = #UNPARSEABLE =VLOOKUP(TODAY(), {Date:Total Backlog}, 4, false) = #INVALID REF…
-
Please Add a Sum Product Formula
Please add a sum product formula to improve ease of calculations without workarounds.
-
Nested IF/AND/OR
I'm modifying a formula used for status tracking and I'm running into an unparseable error that I'm having problems resolving. I want to make the status red (stop sign) if the status is "in progress" or "not started" when the "at risk" column is checked. My understanding is that the formula will look for the first true…
-
Fiscal Year Starts in February sometimes end of January
Our fiscal years (FY), quarters (Q) and work weeks (WW) are giving me heartburn. I realize I need to create a table in order to capture each fiscal year. However, when putting in the formulas so far I am seeing issues with my Work Weeks and Fiscal Year columns. Part one (1) of my heartburn. For example, my work week is…
-
Sheet Summary COUNTIF error when summarising formula driven cells.
Hi all, I'm creating a sheet summary report with the intention of summarising when passed tasks were completed relative to planned completion data i.e. early, on time, late. To do this, I'm using an =IF formula (which works) to define how to label tasks in my "Completion" column based on whether the 'Actual Completion…
-
Calculating Avg Workdays w/ Conditions
Hello! I'm currently trying to calculate the average amount of workdays it takes for each person to complete a specific request on a metrics sheet from a parent sheet. For example: How long does it take me on average to complete a FOIA request? How long does it take me on average complete a litigation request? Request Type…
-
How can I show a colored health dot based on the other colored dots in the same column?
I am trying to have a cell show a colored health dot based on the other dots in the same column. This cell basically shows red if there any red dots, yellow if there are no red dots and at least one yellow, green if there are no reds or yellows, and blue if all other dots are blue. This cell called out should have a red…
