-
CountIf formula using Sheet Reference
Im trying to do a CountIF conditional formula using to columns in a referenced sheet. I"m trying to only count the open Risks. So Status1 is Type (Risk, Issue) Status2 is Status (Open, Closed) This is what I have so far, but it's not taking. Any suggestions? =COUNTIF(AND{PingOne Verify: Risk, Issues, & De... Range…
-
Symbols don't appear anymore when used in a Formula
Hi, please help me ! Symbols don't appear anymore in columns where there is a formula. It only shows the word ("Empty", "Red", etc). Everything was normal. Then I changed the name of a column and it stopped working ! I tried to create new columns, or to use different symbols, even to make a copy of the sheet under a new…
-
Error on copying a formula from one row to the next row
I am using the Survey Intake - Employee Pulse Check template package to create an NPS survey sheet, report and dashboard. I've updated my questions on the template sheet and I am now editing the "helper columns" to reflect the changed questions. I created a formula to count my responses on the first row, but when I try to…
-
Dynamically update form data
Looking for help... I'd like to update the fields on a form dynamically. Example: Use the system-generated Creation Date to calculate a "Delivery Date" 2 weeks in the future and display it on the form. I know I can do this on the Smartsheet but I don't know how to display it while the user is entering information.
-
Is there a formula to enter data if entry was already in the sheet
Hi, If I have a sheet with more than 2000+ entry (some needs to be re-entered) in it with name, phone number, email, address...etc (basic information), is there a way if a person is enter multiple times, it will auto-populate phone number, email, address? Thank you.
-
Checkbox And Text COUNTIF
Hello, I am looking for some help regarding a formula I am trying to get to work. I am trying to count of all boxes that are unchecked and have a text string that records the area STL. The check marked box represents a finished project and unchecked is unfinished and the text string represents the area of the project. I…
-
Vlookup person on other sheet, return reference if a date falls between 2 other dates - V2
Good morning, This is a follow up question on one I asked yesterday and which I closed before realizing I needed some more help: https://community.smartsheet.com/discussion/comment/289238#Comment_289238 @Bassam Khalil helped me brilliantly with the below formula but there is another variable I hadn't taken into account.…
-
Insert a line break and make specific text bold inside a concatenation formula
Hi everyone! I want to make certain specific text bold in a concatenated cell and/or insert line breaks so that the cell output is easier to read, since that is being fed to a dashboard through a report. Current output: Accomplishments: Text. Next Steps: Text. Desired output: Accomplishments: Text Next Steps: Text…
-
VLOOKUP - random responses
Having trouble with random responses from VLOOKUP. What is puzzling is that all options have been copied or transferred the same way but give a different result, any help appreciated!
-
Multiple Nested If Statements with Numbers
I'm trying to build a scoring system based on the number of times a new submission came in for different sites at my company. I have a form set up to feed into a sheet then have a background sheet with a countifs formula to get the number submitted each quarter. From there, I need to change this raw number into a score…