-
Green, Yellow, Red Blue Formatting
Hello, Newbie here. Trying to set some formatting for some specific RYGB and I can only get it to work for Yellow. Any thoughts? I receive the #INCORRECT ARGUMENT error. Thanks in advance! =IF([Completed%]2 = 1, "Green", IF(AND(Today1 > Start2, Today1 < Finish2, [Completed%]2 = 0), "Yellow", IF(Start2 > $Today$1,…
-
Date Calculation Formula to Return Friday of Week Calculated
I'm looking to return the Friday of the week that my date calculation result falls. For instance, I have a formula that calculates a Start Date by using "Due Date" - 40 WORKDAYS. I need to then have the result show the Friday of that week. My first WORKDAY formula works fine on its own, but not with IF(WEEKDAY...... added.…
-
Estimating Available Award Dollars when awards have asynchronous start dates.
Background: We're a research organization that receives a variety of federal, state, and private awards to conduct research. Awards are received throughout the year with a variety of project periods ranging from 1-5 years. Objective: Derive an estimate of how much "cash" we have in the bank at any one time. Averaging the…
-
How to track changes via a report for a single cell in a schedule?
Hello, I have a large construction schedule sheet that I will require updates to "Start" and "Finish" dates. To better coordinate with our project controller, I would like to create a report that shows modified dates within the past week. I currently have a report (see attached picture), that pulls the modified column…
-
Task Dependency
Hi Team , As part of Program of Work sheet for a project , i have created a task which is a collection is set of sub tasks that can be completed if only the subtasks has been completed .However ,i am facing this issue where in my end task completion date gets auto filled as even if the only one of the sub task activity is…
-
How to display results from original smartsheet in another smartsheet to create a dashboard
Hello! I am creating an executive summary dashboard for people external to our company. I have a data source smartsheet (primary) that has a lot more detail that I do not want to give them access to. I would like to create a smartsheet that references specific information from the primary smartsheet, but shows the details,…
-
Using custom value for auto-number in primary field.
I read an old post that said use =[Row ID]1 to copy an automated sequence number in to the field specified. I want more that than just 1,2,3. I would prefer V00001, V00002 etc.. to increment for each new row. Is that possible?
-
Is there a way to restrict a row height?
I now in Excel there are functions to lock certain items and I can use the REPT function to have a minimum visible. However, for fields that require many updates and can take up an entire screen, is there a formula to restrict visible height other than unchecking the "wrap" option?
-
Tabulating Sheet Summary Data
Is it possible to automatically capture the results of a sheet summary on recurring basis and save them to another sheet? Almost like a daily cron job. I have metrics that feed a dashboard from a open issues list, but want to track trends over time based on those metrics. Currently I only have a snapshot of the live status…
-
Count if Specific Text within a Date Range
I'm trying to create a formula to count a specific text within a column only when it's during a specific date range. I can't figure out where my error is. =COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], >= [2020-08-01], [Date]:[Date], <=[2020-08-31])
