Formulas
Discussion List
-
Countifs with reference to another sheetIn Formulas and FunctionsHello, I am trying to use the following formula: =COUNTIFS({Facilities Scorecard - All Lots Region}, "1", [{Facilities Scorecard - Traffic Count Standard}, "Y,"]) and =COUNTIFS({Facilities Scorecard - All Lots Region}, …Answered - Pending Review 6 views 4 comments 0 points Most recent by AMendy12 Formulas and Functions
-
Count Netdays if Project Status is "Complete"In Formulas and FunctionsHello Forum, I am having difficulty writing a formula to count NETDAYS if a project status is "Complete". I hope this is not too confusing, but here goes..... 3 COLUMNS: "Project Status", "Actual Start Date&q…
-
Change symbol based on dateIn Formulas and FunctionsGood morning Everyone, I have been having some issues configuring a formula in smartsheets. Currently the only two columns that matter are named "Status" and "Last Run". What I'm trying to write is a function in which…
-
Date 6 months out (to the day)In Formulas and FunctionsHello colleagues and guests. I would like to learn a forumula to retrieve a date that is exactly six months later than a known date; i.e. Jan 1 - July 1, Feb 4 - Aug 4. Presently, I'm using 182 days, which is close, but not exact. I'm also…
-
Programming with SmartsheetsIn Formulas and FunctionsIs there any way that I can use external programming to effect my Smartsheets. Is there an API that would let me right seperate programs to control my Smartsheets?Answered - Pending Review 8 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Cell Link or Formula for Start and Finish DatesIn Formulas and FunctionsI'm looking to find a solution to populate the start and finish date columns based on info in another sheet. However, because I have dependancies turned on the date columns cannot use a vlookup or other function to pull the dates from anot…
-
need help with an IF functionIn Formulas and FunctionsHello community, I am trying to come up with a cell formula that is a simple difference function, but I need it to be triggered by the number in another cell. It is for an inventory/ordering sheet. Someone will count the inventory and typ…
-
If with And Formula helpIn Formulas and FunctionsHello, I'm trying to write an If with And formula to flag if my micro/QC column contains a specific phrase, and my Date Submitted column is past its date by 12 days. Here's what I have =IF(AND([Date Submitted]@row - TODAY() >= 12, [Micr…
-
Date Formula AutomationIn Formulas and FunctionsI am trying to auto generate a start and end date for each task in a project tracker. I want the start date of the new task to look at the prior task, add the number of days to complete and then calculate the nest start date (and end date…Answered - Pending Review 17 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
SUM a value found in a string within each cell across a range?In Formulas and FunctionsDue to memory limitations i have all projects rolling up some user metrics data into a single cell per project. This cell has a text string with a value, followed by another text string and value, over and over for all my variables, for ex…Answered - Pending Review 21 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
