-
Vlookup and Zip Codes
Can I use the vlookup function to populate city/state and zip for events management and tax purposes? If yes, what is the formula? Thank you for your help in advance
-
Formula
I have a drop down menu on a form with the following possible responses for multiple questions: 1- Poor 2- Fair 3- Good 4- Very Good 5- Excellent I want to create a new column that is the average calculated numerical value based on the descriptive rating. Is there a formula to collect the average number (basically, how do…
-
Can the % complete for a subtask be updated with a formula?
Hello, I am trying to figure out if it is possible to update subtask % complete to automatically update via a formula or input from another field. Thanks in advance!
-
Max Children with Dates or Text
Hi All I am trying to pull either a max date or text into a parent row and I am getting an #invalid data type error. The column is a date column. If I change it to a text column, I receive #invalid column value. I'm not sure this is the correct formula. I am using =OR("TBD", MAX(CHILDREN()). Any ideas?
-
How do I get the Gantt view to show multiple single dates?
We have project managers and folks in our procurement office that track multiple dates on their sheets on the same line because it is one project. I am curious if Smartsheet has a plan to allow all of these dates to show up in the view at some point? It would be very helpful for project management. Thank you.
-
Column with a running total by location
I have a column for Address, City, and State. When entering data I am able to get a column that will count the total for each, but I want to add a column that shows the running total for each. For example in row 1 I enter data for location x the running total would show 1. Then in rows 2 and 3 I enter data for location y…
-
How to pull information from a cell of different sheet when the given conditions are met?
I tried using If & Contains but i realized it is doing for the columns but I required my formula to look at rows not the columns. And if given conditions are met, I want to pull the information from that row. Please help?
-
How to block a cell on formula
Hi, I want to know how can I lock a cell in a spatial working formula. Example: = IF (AND ({PROJECT CASE TEST Rank 7} = January1, {PROJECT CASE TEST Rank 6} = January2), {PROJECT CASE TEST Rank 8} + {PROJECT CASE TEST Rank 9} * January5, "") When I pull the formula left, right or down, the cell formula can't blocked and…
-
COUNTIF using Count(Ancestors)
I am trying to use the COUNTIFS formula to return a count of items within a date range. The issue is a large number of the rows have indented/child rows that I do not want included in the count. The formula I have tried is: =COUNTIFS({FOLLOW UP Range 1},COUNT(ANCESTORS()=0)>DATE(2021,1,1){FOLLOW UP Range…
-
MONTH/YEAR formulas based on date column
Hi there, I have a column for "Report Date", "Date received", and "Month/Year". In my "Month/Year" column, I want the report date to be written out instead of 1/6/21 as January 2021. However, sometimes our "Report Date" column is blank/has the word "Skip" written when we don't have to write a report for that row. When that…