-
Copying column headings and layout from one sheet to a new one
Good morning all We've had a message pop up stating that we've reached our quota for one of the sheets we're using. I'd like to be able to quickly replicate the sheet again on another new sheet, along with the form we use, colour scheme, and current layout. Is this possible?
-
Formulas // How to set up one sheet writing to another
I created a project request form for one of my team members -- others on the team enter a request by filling out the form, and so the sheet becomes his workload queue. Another team member has a schedule on a separate sheet with some items assigned to the same resource. She asked if there is a way that if she selects his…
-
How to Applying Conditional Formatting Efficiently Across Entire Sheet
Can you apply a conditional format of say "anytime the value '0' appears throughout the sheet, change its color to RED" efficiently or do you have to make one conditional rule per column for all the columns you have in the sheet? Additionally, is there an "OR" function within conditional formatting? For example, "If Column…
-
Conditional formatting with heirarchy and card view
Hey All, I'm having difficulty getting my card view tabs to show a certain color based on percentage complete for the subtask. When I create the rule it either highlights all the subtasks based on the parent percentage complete, or does nothing at all. I am trying to have individual subtasks change color base on…
-
Conditional formatting and uniquely identifying cells
Hi, I would like to only apply conditional formatting to cells that are percentages. My rules currently set any cells that are over 100% as red, and 100% or less as green. Due to the red rule formatting any cell over 1.01 a lot of my data is showing as red, wheras this really needs to be white, there is no cause to flag…
-
Is there a way to define "today's" health, based on today's date and corresponding "% completion" va
Hey everyone, I've got a set of data pulling in completion % by date, and want to give my team a quick snapshot of overall health of the project based on completion % for TODAY(). I have used the following formula, which works for giving RYG per day: =IF(AND(Date9 = TODAY(), Difference9 < 0.05), "Green", IF(AND(Date9 =…
-
File Upload from Customer into their Designated Row
I was hoping somebody could help. I have a form set up where customers can upload their artwork directly to our sheet and once checked I send an approval request as a proof. However if the proof is declined or we check the file and it isn't print ready we require customers to upload a new file (artwork). I have tried this…
-
Project Management, If then Statements
Hi, I was wondering about Project Management using Smartsheet. I am trying to create a project where there are many options or collateral pieces that key stakeholders can request from our marketing team based upon the amount of ROI projected and what they rank. E.G. Gold= anticipated $$$ Silver = $$ and Copper = $ If they…
-
Working Days
Hello, I am trying to set conditional formatting to highlight due date cells when it is within 3 working days, however the sheet counts Saturday and Sunday as days. Is there anyway of setting the sheet so saturday & sunday do not count as days?
-
Data -> Exported Form
Hello, I am relatively new to SmartSheets but I am looking to place a form we have now into smartsheets to collect the data there. However our Executive Team likes the look of the original form... Is there a way to export data in a way other then in a grid/ excel looking chart? Id like to customize it and have it run only…