-
Conditional Formatting To Red out a Row, if ID# has been used before
Hi all, I am trying to create a conditional formatting to mark a row Red if the ID# has been used before. I have plenty of conditional formatting experience however I just can't seem to figure this part out. Basically in a list of projects I.e 1,2,3,4,5 they move at different speeds and sometimes a project wont be on a…
-
Formula Help - Check the box once per unique ID
Hello - I will try my best to explain my formula question. I am using DataTable to import a few hundred to a few thousand rows of data monthly into a targeted sheet. After 180 days from a specific date column, they roll off the targeted sheet. My goal is to show the Unique Rows like the "delete duplicate" functionality in…
-
"Invalid Data Type" Error - Need Formula Help!
I am trying to add 3 years from the "Date Completed" column; however, I'm getting the "INVALID DATA TYPE" for the cells where "Date Completed" are blank. I'd like for the "Date of Renewal" to stay blank if the Date Completed is blank. =DATE(YEAR([Date Completed]@row) + 3, MONTH([Date Completed]@row), DAY([Date…
-
I am trying to manipulate my SUMIFs Formula
When Using SUMIFS(Range, Criterion Range 1,Criterion...) I have multiple columns for example Estimate Spend, 25% spend, 50% spend, Rather than having multiple %'s of spend I just want to be able to use 1 reference and multiply it by 0.25 or 0.5 in the first "Range" category so =SUMIFS({Spend} * 0.25, {Phase}, "phase 1",…
-
Rename Headers within the Conversations Window per Sheet
Hello, Currently, the titles for rows within the conversations section of a sheet show only the value within the Primary Column. I need to use the primary column for reasons other than a descriptor. I recommend being able to select a column to display as the header for conversations. Maybe like a "pseudo-primary column".…
-
Merged: Filter Individual Columns from Sheets
This discussion has been merged.
-
Can a column be formatted for HH:MM entries?
I need like to track working hours in sheets so it would be helpful to format the columns as an hh:mm entry, is this possible? Thanks
-
Merged: Filters to include columns
This discussion has been merged.
-
Can a range be specified with a beginning and no end?
I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like additional rows to automatically be included in my summary calculations. The formulas I'm…
-
Formulas with multiple inputs in smartsheets. Help needed!!
This has been a challenge for me to figure out using the smartsheet platform. I am developing what is essentially a big calculator. The formula that I am trying to implement is: [($26,000 * DTH) + (Risk R * Repair Cost) + (Risk A * repair cost)] * frequency). In this database, each row represents an additional input. The…
