-
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…
-
why is Primary column not left justified?
No matter what I've tried, my Primary column seems to display with spaces before the first number, like it's more center justified than left justified. I have many columns so I'm always trying to reduce column width whenever possible and my numbers get cut off if I try to do this with my Primary column - it's like the…
-
Auto Date on Forms
Does anyone know how to have a template form automatically use the current date? I have a form I use for collecting data and it has a start date, due date, etc. I would like it to automatically use the current date as soon as the Smartsheet is generated from the template. Is that even possible? TIA
-
Need Help with Formula, want all project summary sheet to record most recent step completed
Hi I have a summary sheet that contains all projects that my various PM are working on, the project summary sheet looks like this: Each project then has its own sheet for the PMs to keep track of what steps have been completed for the project, looks like this: On the summary sheet in the "most recent step completed" column…