Formulas
Discussion List
- Hi there Im pretty new to smartsheet and trying to get a stsus column to return a symbol value based upon date and progress column I'm tyring to get the following IF date is in thepast and progress is…
- Hello, I have 2 sheets: Sheet 1: list of videos Sheet 2: list of products I want to put a check in the cell for all rows on sheet two where the Title, Edition, and Author match from sheet 1. Here's th…
- Hello! I am trying to get a formula to, automatically update status colors for the child and parent. The Parent is distinguished by "Main Project" in the "Project or Task" Column. I would like the Par…
- I have 3 columns in my Project Plan that I am using to have team members fill in to indicate if their task is off track, on track, or complete. I only want them to be able to check one of the boxes. I…
- Hello Experts, I need to calculate SLA Breach, based on a ticket severity and Number of days consumed. LOW - Greater than - 7 days MEDIUM - Greater than - 4 days HIGH - Greater than - 2 days CRITICAL …
- Hi there, I need assistance on this formula: =IF(OR([ Company’s intellectual property Co-owned]@row = "No", [ Company’s intellectual property Co-owned]@row = "Unsure"), [First Name]@row + [Last Name]@…
- I'm working on a project summary report where I want to pull over the {B2B Mktg - Spend} cell of the sheet I'm referencing where the year matches the parent, quarter matches the metric@row and the row…
- This idea is to pull text from one column to another; examplet Below Primary Column: Country Names Child Primary Column: Secondary Project Workflow 1: When a new row is added, place formula to pull te…
- I am trying to average a column that lists the projects duration......some of the cells in this colum are blank, how do I average this? =AVG({Master Summary Duration}, IF(ISBLANK({Master Summary Durat…
- I am trying to create a helper column that checks whether a cell in a nearby column ("Project" in this case) has been hyperlinked or not. I want to return 1 if True or 0 if False. Something like this:…
