-
Match or Index
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
-
Calculate number of days between two dates in the same column on the same sheet
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal toā¦
-
Countif, index/match
I'm working on a formula that will return a count based on a matching dates and the word "Quality", but I'm getting the unparseable error. I'm sure it has to do with where I'm putting the ) and ,0 ,1. Here are some that I have tried:
-
Using lookup formulas with Contact Cells
Hello, Trying to sort through an issue I have been having. I am trying to lookup contacts on one sheet against a source sheet to see if they are present. The sheet I am using has the contact in a contact column, but only as an e-mail with no name associated. The source sheet has BOTH the contacts e-mail and name, but byā¦
-
How to use previous cell value (from cell history) in a formula?
I have seen this question asked multiple times in the forum, but I couldn't find any clear answer provided in the answers. Please excuse me if a solution already exists, but if not, will someone please let me know if it is possible to use a previous cell value (from cell history) in a formula? I am specifically trying toā¦
-
How to perform calculations on individual cells of a range - within a Collect function
Hi folks! I'm trying to do a calculation with ranges inside a Collect function. I'm not getting the correct results. The goal is to calculate a % variance between a forecast amount and an actual amount. This needs to happen 12 times, as this is a monthly forecast/actual combo. The goal is to Count how many projects, run byā¦
-
Cross-Referencing Another Sheet for Matching and Looking Up Values
Hi! In my first sheet, I have a column "Date Submitted to Courseware". Then, someone selects an "Analysis Priority". First sheet The Analysis Priority should look up the References sheet to the columns for AnalysisPriorityTypeDropDown, match that, and figure in the AnalysisPriorityTypeValue number of days, and figure inā¦
-
Ranking Priority of Projects
We have a column of " Universal Priority" in the Portfolio. It is only manually populated for projects that are not completed or terminated. Is there a formula that can do this and handle changes such as when a project gets completed or we need to update our #33 priority to #1 an all the projects in between need updated?
-
Automation not triggering when % Complete shows '100% instead of 100%
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, butā¦
-
Formula for populating date
I am needing a formula that calculates Termination Date (date property). The formula needs to look at Initiation Date (date property) and Term (text/num) which is based on # months, to calculate Termination Date. In this example, the termination date should return a value of 1/01/26. Thank you!