- Flags using IF AND formula with multiple sheets
Hello, I would like to create a formula where it flags for the following information: Donor Center = other sheet column Donor Center AND Job Title = Ops Admin QAS AND other sheet column Position = Quality Assurance Supervisor Then Donor center = other sheet column Donor Center AND Job Title = Ops Admin Assistant Mgr AND…
- Generate a date 48 months from "Delivered Date" and at the End of Month
I am tracking vehicle leases for our company and I would like to have an "Expiration Date" auto generate 48 months later. The kicker is our leases always end at the end of the month so is there a formula that can generate that for me? I have been able to get the 48 months generated but there is not an EOMONTH function…
- IF / OR formula then Check a Box
I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = "Active/ Open to Accrual", 1) OR([Study Status]@row = "In Start-Up", 1))
- Project Variance Formula Using Levels
我需要帮助它的一个公式tes variance between actual durations and planned durations set at the start. We frequently need to reset the baseline throughout a 3-5 year project, and I would like a historical record of where we started and where we ended, without having to copy/paste current baselines before they…
- populate value within the same ID number with multiple criteria
Hi, I'm trying to create a formula that will populate Column Outcome (example highlighted in red). Within the same ID#, it'll populate the assignee based on: 1.) Within the same ID #, if column 5 has a %, and the assignee is not Sam, it'll populate the assignee name within that ID # 2.) If it's Sam, then it'll look at…
- Unique codes
Hey all, I am trying to create a system that will check a unique code that is entered through a form and display if this code has been used already or not. I have a formula in the summary sheet that will asses if the code has been used or not: =VLOOKUP($Code$1, {Z Codes Trial Database Range 1}, 3, 0) The problem is that I…
- Formula - convert a name to e-mail address
Hi all, I am looking to convert a name to a e-mail address using a formula. This is the example: convert 'Andreas Johnson' to 'Andreas.Johnson@company.net'
- % Complete Formatting in JOIN Formula
I am trying to Join various data points into one cell and when I join the % complete, it changes to decimal format. I've tried adding Value in from of the %complete, but get the same result. Can someone let me know if there is something I should add to my join formula to convert the decimal to percentage? Thank you Tiffany
- Merged: formula in a report view
This discussion has been merged.
- Allow formulas to function in reports
Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather updates, which results in me being told "your smartsheet is broken" because the formula columns do not update.
