Formulas
Discussion List
- Hello, I am attempting to take a previous intake from and update the new form will allow for more "automation". On the form the requestor/submitter selects a theater and region/country. Once the intak…
- Hi Team! I'm hoping to get some help on Sheet Summary formulas. As you can see per my screenshot below, we have 2 projects. I'd like to do 2 things on the sheet summary: Be able to filter by project n…
- SHORT VERSION: How do I write a formula to pull a date from one column and update JUST the year of that date if a condition is met in a separate column Very Long explanation: I have a data base of con…
- Total noob here. I have a master sheet with 4 critical dates in regards to completing a major project (new restaurant opening). The critical dates are subject to change as some parts of the project ar…
- Hi! I am building a team monthly capacity tracker. Right now, it's all in one sheet and I have filters set up based on the 'Owner' column, so each team member can view and update only their projects a…
- Good morning community I hope you can help, I just can't seem to get this formula right... I have the following status categories on a color wheel Red - Overdue Yellow - Task Outstanding Blue - Invest…
- Hello! I'm trying to auto-generate IDs that build off of another ID. The formula I'm currently using is: =[Initial ID]@row + "-R" + COUNTIF([Initial ID]:[Initial ID], [Initial ID]@row) I would ideally…
- I've put together a function that pulls an autonumber value from a cross-reference. The problem is that the formula does not evaluate on all records. In the first snippet below the Row Record field do…
- Hi! Currently, I have a formula in place to indicate R,Y,G Health based on the Start/Due Date. Is it possible to add an =OR function so that if "Status" column is switched to complete the Health will …
- I'm new to SmartSheet and am struggling to create a formula for the following: If number ends in 0-29, round DOWN to nearest 0.95, (ex. FLOOR(A1,1)-0.05). Otherwise, if number ends in 30-99 cents, rou…
