-
Using column formula when the formula in row 1 is different to the other rows...
Hey guys, I'd be glad of some help.... I'm trying to create a column formula which uses a piece of data from the row above, which it doesn't seem to like, as it appears that the formula must be created in row 1 for it to work? I want to use column formula as I'm adding to the sheet via a form and want the column to auto…
-
Need Help With Tricky Formulas
For my projects (one per "column"), I have a column for "Deadline", "Remaining Hours", and "Networking Days Between Today and Deadline". Then there are columns that need formulas that need to calculate "splitting all remaining hours" evenly across months up to the deadline (and a column for August 2024, September 2024,…
-
Are the SUMIFS formulas working properly?
This formula worked yesterday in my sheet summary field and today is not working.. =SUMIFS([Remaining Work]:[Remaining Work], Category:Category, OR(@cell = "FC Support", @cell = "Maintenance & Reliability", @cell = "HR", @cell = "Chewy Leadership Academy", @cell = "FC Operations", @cell = "FC Systems", @cell = "Supply…
-
How to show drop-down selections in children rows on parent row?
Hello - I have a Parent Row that is an Item (Hardware & Tools) and children rows that have specific departments associated with each hardware/tool listed. Is there a way the parent row will automatically show every department that is selected in the children rows? Screenshot below: So on the hardware & tools parent row I…
-
Please help with Formuala
I am trying to count the number of Contact Replies when the agent is 'x' and the status is 'x' =COUNTIFS({HDT_SourceSheet Range 2}, Agent@row, {HDT_SourceSheet Range 3}, {HDT_SourceSheet Range 1}, OR(@cell = "Closed", @cell = Solved")) Example Sheet Columns (Range2) (Range 1) (Range 3) Agent Status Contact Replies Ashley…
-
Is this an IF THEN helper sheet or just adding a new column?
I am trying to pull information to a smartsheet ("working") based on matching two columns on a separate "helper" sheet so for example on my "helper" sheet I have something like Company Rep ABC Computers John Smith Egghead Sam Talbot Disks R Us Joe Talco On my "working" smartsheet I need to be able to enter the information…
-
Populating master sheet from another sheet it produces.
Hi everyone, long story short, our team has a form where individuals can submit issues for upper management review. Once our team reviews, we select "yes" under "ready for SDLT review". this is where my question begins… SDLT will meet as a group separately, and I'd like them to only see items which we've selected "yes" to.…
-
Cop row automation target sheet dropdown field does not populate from source sheet
I am using automation to copy a row from one sheet to another. The source sheet has a dropdown Assigned to contact list field. The target sheet has the same Assigned to contact list field. The selection from the source sheet does not copy to the target sheet. How can I make this work? Thanks for your help!
-
Can someone help with this formula
We are trying to read 4 columns and combine to get Status. It works in excel but not in smartsheet. =IF(ISNUMBER(SEARCH("Other",[Sys_Class]@row)), "Others",IF(ISNUMBER(SEARCH("NO MATCH",[operational_status]@row)), "Completed",IF(ISNUMBER(SEARCH("Vernova Infra L2",[support_group]@row)), "Completed",IF([Planned Date of…
-
Need a formula
I am novice at best when it comes to anything related to formulas! I collect data in a grid format starting with a "Date Created" column. In a 24 hour period there are typically 50-60 entries. Each entry collects two points of data, in this case Weight and Gauge of material. Each column compares actual to a specification…
