-
Round returned date to working day?
I've been using a formula to calculate due dates, which are always 90 calendar days from the original date column. This is the formula: =IF([Resubmission Required?]@row = "true", [Date Decided (Approved/Rejected)]@row + 90, "n/a") However, because we are required to calculate these dates in calendar days, many of the dates…
-
Automated symbol isn't switching
Hi everyone, I am trying to automate symbols. The logic should be if the specific cell is below 90% then mark it as a red symbol, if it is greater than 90% mark it as yellow if it is greater or equal to 100% mark it green. This is what I got: =IF([Actual vs. Target Sq ft. Produced]@row < 0.9, "Red", IF([Actual vs. Target…
-
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…