-
Making sheets from a sheet
I know how to copy info from one sheet to another sheet. My question is...I've created an Application form for my employees to fill out. Is there a way to set up where a new sheet is created for each applicant and copies their info to it also. Meaning...Joe Smith fills out my application - then Smartsheets creates a brand…
-
How do i set up a conditional format, when i want more than one person in the assigned to column
I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?
-
How to Format Date-dependent Color-changing Cells (3 total columns)
I need to create a Smartsheet for tracking documents, the date of last review and a color changing column reflecting the date of next review. In column A I need to list the document names. In column B I need to list the date of last review. I need help to format column C cells. 1. I need for Column C to populate a date…
-
Color Coding Calendars - Different Colors for Different Calendars, but from the same sheets?
Hello! I have a workspace with a ton of different sheets that each represent a project timeline for a single client. We are creating different reports to pull together program/client level views for things like team PTO, client due dates, internal resourcing priorities, etc. We use the calendar view of our reports…
-
Is there a way to have a cell match the conditional formatting the referenced cell has?
I'm creating a sheet where each cell is referencing a different cell on a master sheet. In the sheet I'm creating, is it possible to have the populated information in each cell match the conditional format from its reference cell? Example: In the master sheet, if the cell contains a date that is in the past - it turns the…
-
different color per row
how i can to do an automatic different color per row ? see example from excel:
-
Conditional Formatting - Dates in the past
Hi, I want to add a conditional format on a column holding dates that will highlight those dates which are over three years ago. I thought I would be able to pick "is not in the last (days)" and enter 1095, however it only shows "is in the last (days)" For now I have had to add two conditions: "is in the past" AND "is less…
-
Averaging a month and year of data
I want to average the month of April, 2022. I can't figure out the month, much less the year. I did look this up but I can't seem to get it to work. =AVG(COLLECT(Boiler Gas Usage}:{Boiler Gas Usage}, {Date}:{Date}, IFERROR(MONTH(@CELL),0)=4))
-
Merged: Ability to create the Conditional Formatting for multiple columns / Range of columns
This discussion has been merged.
-
IF formatting combined with a calculation
I am trying to include a calculation only if a certain qualitative value is met. Trying to have the column indicate "Days Over Deadline" by subtracting the "Submission Deadline from the Submission Date," but only if the "Assessment Stage" is Issued. =IF([Assessment Stage]@row)="Issued", =SUM([Submission Date]@row) -…