Hello, I am doing a cross sheet formula with a SUMIF. =SUMIF({CLONE BATCH ID}, [CLONE BATCH ID]@row, {CLONE CUT QTY}) I am repeating the formula I have used in other sheets. I re-watched the formulas …
Hello, I have the following Smartsheet: In this Smartsheet, I'm building an asset booking system and, for the 'Asset Available During Your Booking Date Range?' column, it displays whether the particul…
Hi, I need help creating a formula to summarize an average using Sheet Summary Columns, I have the following sheet columns: Current Date, Average Rating, I have the following summary columns: From Dat…
Hi, There are codes that I need to use that start with letters and have numbers after them. I want to be able to use the drag to autofill (in the lower right corner of the cell) the rows below it, wit…
I just spent a very long time figuring out how to make the %% complete column auto populate based on the dates. I was proud of my work until I had to 'enable dependencies' so that I could have predece…
I'm not sure how to isolate the largest/latest date from a sheet that has multiple records with various pay dates for a single individual. The sheet has about years worth of entries for the company. F…
Hi, We noticed "Attachments" in a sheet tend not to appear intermittently without any rhyme or reason. When it does occur, a simple refresh corrects the issue. Sheet is shared among three teams, any t…
Hi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will u…
I've been doing some research on how to append values from a sheet, to a form link, so that when the user clicks on the link, certain fields are pre-populated. I've run into two issues that I'm lookin…
