Hi all! I am back again with another Smartsheet question! This time I'm not certain if what I'm asking for is even possible. I was wondering if it would be possible to format 3 columns to make them sm…
Good morning. I have to create 2 forms which will populate parent rows and child rows. I need the parent rows to have a unique quote ID (have this set up now), and child rows to either not have an ID,…
Hi all! I am very new to Smartsheet and am trying to come up with a solution regarding taking an average of matching column values. To explain in more detail, I have "Week Of" column and a "Days to Co…
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…