-
Help converting an Excel function
Hello, I'm currently using the following Excel function(s) to return a True/False value to determine if any of the alphabetic values listed in the AF column are present in the H2 cell. I'm having trouble using both the FIND and CONTAIN functions to include a range of values to search_for.…
-
Setting Formula using RYG
Hi! I'm trying to set up a formula using the Red, Yellow, Green symbols but I'm having difficulty doing so with how we use it. So basically, we have multiple columns we use to grade our employees in a QA setting so example Red=No, Yellow=Somewhat, Green=Yes. I am not even sure if this is possible. Any input advice how to…
-
NEED TO ADD LAST COMPLETION DATE IN COMPLETION DATE COLUMN
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Completion Date will register the date of last row that changed to "complete" status. NOTE: The Record a date automated workflow…
-
Creating timesheet with formulas
Hi All, I am a newbie to Smartsheet's and this Community. I require some urgent help in regards creating a timesheet for project. I am getting a lot of error when trying to create this sheet in Smartsheet's. I Originally created this in excel with formulas however when i have imported this file over into Smartsheet's all…
-
Sum extending range
I need a formula that increases the sum range as more data is filled in. The formula must be part of the column, at the top and add data as it appears at the bottom.
-
Current Month Spending Formula
Hello Community, How do I calculate how much was spent this month using the below columns? [Spending Date] Date Format [Spedning Amount] USD Format Something like =SUMIF([Spending Date]:[Spending Date],(MONTH(TODAY())), [Spedning Amount]:[Spedning Amount] The Issue is that (MONTH(TODAY())) returns the current month in a…
-
Issues with Cross Reference and VLookup
I have been trying for several days to get cross referencing to work, it is stuck in the processing status is what I have noticed. I even tried to use different browsers to see if that was an issue. In order to provide data for testing, I cut down my files to remove sensitive data and just included the necessary data, now…
-
Pull cell value based on matching value in two sheets
Hello all, hoping someone can help me with this question. I need to pull a cell value into Sheet 2 based on a shared cell value in Sheets 1 and 2. Specifically, I need to pull the value from the MIN Score column in Sheet 1 to the row with a matching COSMOID in Sheet 2. For example, Client A has COSMO ID 123456 and a MIN…
-
Nested IF formulas
Hello, I'm new round here. Please excuse the entry level ask. I have an array of 3x3 cells. In each row only 1 of the 3 cells will be completed and I want to return a value from another cell depending on which of 2 the 3 cells are blanks. I have these 3 formulas working as expected in isolation, but I am struggling to nest…
-
Filter by formula
I have several columns which I typically have a formula in nearly every row (like you would use a column formula) but I've decided to have the formula be cell based because every once in a while, I need to input a manual number instead of deriving from a formula. My current situation is that I'm using reference manager to…