-
Monthly Report Generation
Hi everyone, I need to create a monthly generated report, is this possible? I have an online form that departments will submit information to. The monthly report that needs to be generated will be the same information. Should I just create multiple filters? must be a better way. Not entirely sure of the architecture for…
-
Cross Sheet Distinct Count Formula
I'm trying to count distinct values in a different sheet using a cross sheet formula. More specifically, I have parent/child rows, and I only want to count the parent rows. The child rows have duplicate values in the column that I'm counting, which makes me think that something like countif(distinct(something...) will…
-
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?
