-
Creating and maintaining a graph of values from several sheets
I want to graph a specific set of values from a number of project sheets. Each project has it's own sheet and there are certain values associated with the project that I want to show as an aggregate graph. So using "Percent Complete" as my example, for 20 projects I'd like to show a graph of the distribution in terms ofโฆ
-
Hello, I need some assistance with a forumla
I"m trying to set the status in a field to display blank "" if the Start date has not been reached. I'm using the following formula: = IF([Start Date]@row < TODAY(), "") I think this should work, but it is not. Any help you can provide would be helpful.
-
Status Roll Up to Parent
Hi, I have a column that has the following status distinctions: Remove Not Started In-Process Final Draft Ready for Group Review Group Review Complete Final TechPubs Complete PTP-In Process PTP-Approved I am looking for a formula that would be set for the parent but only show: Not Started In Process Complete How shouldโฆ
-
Combine COUNTIFS with a date and row criterea
I have two formulas working independantly and now I am trying to combine the critera but I am not sure which formula to use. Working formulas are: =COUNTIFS({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, >=DATE(2020, 1, 1), {ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, <=DATE(2020, 12, 31))โฆ
-
IF, AND formula for checkbox
Hello, I'm trying to make a formula for a checkbox column where if the column titled "Expected result" is positive, but the "Results" column is negative, then the checkbox will be filled (and vice versa if expected is negative and result is positive). However, I cannot say if the expected result column and results columnโฆ
-
trying to add a field to a logic flow
Hello, I have created a field "New Country". I want to use this in a logic flow "Country where work is being performed". The logic: If "other", then enter New Country. However, they system is not even showing me "New Country" as an optional field to pull into the logic. Any idea why? Thank you, Paula
-
Sum Collect Index Match with a calculation...
I have a list of items and costs associated with the item. I would like to build a formula without the use of a helper column to calculate the total Value of items based on the quantity of items. The list of items is about 300 lines and the number of "people" will be a fluctuating quantity... I would rather not createโฆ
-
Column formulas in cross sheet calculations
i am trying to count how many coils have at least 1 piece of missing test data. The report I pull will show all the information and the missing test data by type. I have created a set up to pull the names of the missing data into one column called missing test data. I also have a month/date column. I am trying to calculateโฆ
-
How can I automatically get all files in a folder for a report, even when new files get added?
I know that I can click on the folder that contains a set of sheets and it will pull in all those sheets, but when I add new sheets to the folder I still have to explicitly select them the next time I open the report for them to show up. Is there a way to trigger the inclusion automatically or am I doing it wrong?
-
How to track burn rate
I am trying to write a formula for burn rate in smartsheet. (Summary11 - Summary14) / (TODAY() - [Delivery Date]19). I want this formula to extend to [Delivery Date]514 as the data is being entered each day. When I use [Delivery Date]514 in the formula I get # DIVIDED BY ZERO error message. When I include the IFERROR inโฆ