-
How do I calculate the sum of children rows only when their corresponding "checkbox" is unchecked?
Hi, I'm creating a sheet to track the progress of a photoshoot. I want my "Price2" cell to total the cost of children rows "Price2" and "Price3", etc. The cost will only ever be $47.40 or $0. (When the check mark is enabled, it indicates the photo has been taken, and therefore removes the associated cost). I want the total…
-
Compare two sheets; flag a name that has not submitted a form
I'm trying to flag individuals who have NOT submitted a form, but am coming up short on the formula. Sheet A Memberlist has a list of all the individuals that need to submit the form. Sheet B Feedback is the form data after it has been submitted. I want to use Sheet A Memberlist as the reference for who is supposed to…
-
Average days open
=AVERAGEIF([Closing Date]:[Closing Date], "", [Days ago]:[Days ago]) Im trying to average the amount of days a case is open by selecting the rows that have a blank closing day which means that they still open. but i keep getting #INVALID DATA TYPE thank you in advance
-
Perform formula if value is found on another sheet
Hello Smartsheet users, I am attempting to create a sheet that will provide me with Weekly Usage totals of an inventory item so I can use the data to create better forecasts and projections. There might be a better way of doing this but as of right now my plan is as follows: Active Sheet contains all of the current totals…
-
Deadline Formula displays Past Due when dates are blank
Hello, I am using a fairly extended IFAND formula for determining task completion based on dates entered (Upcoming Deadline, Due Soon, Due Today, Past Due, Complete - Ahead, Complete - On Time, Complete - Late). When the dates are all blank, Past Due displays, which is not correct because the task hasn't even come up. Is…
-
interactive Dashboard
HI All! I'm trying to create a dashboard where my team can go and select a model number from a drop down, and the dashboard would then display all the features and functions of that particular model. Is there anyway this can be accomplished? Alternatively, is there anyway I can automatically generate a document from…
-
Remove Middle Initial from the End of a Name
Hi, I'm looking for a formula that will remove the middle initial from the end of a name. For example, I currently have: Biden, Joe R Trump, Donald J Obama, Barack H Bush, George (In this scenario let's assume George Bush has no middle initial) and my desired results are: Biden, Joe Trump, Donald Obama, Barack Bush, George…
-
Formula for the arrow Visual symbol
Good Morning, I'm looking for a formula for the arrow symbol, If the priority of a particular project changes then I would like for the arrow you move up or down within the column. I hope this makes sense, and thank you for any help that is given.
-
Preventing actions on certain days
I am creating a project plan that will be used as a template for several similar projects. The project has several shipments dates for "in process materials" to client for testing, but such shipping cannot occur on a Thursday or Friday. How can I set a rule that if the project automatically says something show ship on a…
-
Report to show last data entry only
Good morning, I am looking for a report to return a column value from the last sheet data entry. Essentially, I would like to create a dashboard that tells me whether my machine is online or offline based on the data that the operator puts into the highlighted column. I'm guessing that generating a report would be the best…