-
Countif within a If calculation
Hi, I'm new to Smartsheet and I'm trying to get a calculation working, which I cannot seem to work out what I'm doing wrong There is an issue with Countifs in the False option, however, if I put just this calculation it in a separate cell it works fine. the error I get is #INVALID OPERATION. =IF(COUNTIFS({Date}, HAS(@cell,…
-
Need help with an index/match formula
I have two sheets. A project plan sheet with contacts in the assigned column, then another sheet called Team member that lists the team Member name along with their departments. On the Team member sheet, I want the column to auto populate with either Core or extended depending on if their name displays anywhere in the…
-
External email hyperlink
Hi, Is it possible to enter a hyperlink to an external email (eg. client, who does NOT have access to the SmartSheet)? We would like to have this in order to be able to write email to a client by just clicking at is email within our Smartsheet. Thank you for your help!
-
Copy automatically partial data from master sheet to different sheets
Hi all, This is my first post, I hope you can help me: We have created a form that populates essential data on projects, and we have created some sheets for different purposes. For instance, we have one for membership, one for tracking progress, and one for contacts. All of them have several columns that are the same, and…
-
Collecting/Counting Data from Multiple Cells/Columns
Good morning, I'm using a formula to capture the total amount of "Extremely Satisfied", "Very Satisfied", and "Satisfied" in the "Satisfaction with level of technical knowledge" column for each quarter. =COUNTIFS({Satisfaction with level of technical knowledge}, "Extremely Satisfied", {CY & Q}, "2024-Q1") What I'm trying…
-
CountIfs Formula
Hello. I am new to Smartsheet and having some trouble with the countifs formula. I have two columns I would like to use - department and status and have created a sheet just for the formulas (to be used later on a dashboard). I would like to display the count of each status for the department (i.e. IT has 3 in progress and…
-
Why is my formula not working?
Hi all , looking for some help on this formula. I have done 2 example below of what i have tried but doesn't seem to be working. The Column i need to show dates if certain criteria meet. If you can help that will be great =IF([Remedial Status]@row = "Remedial Required", IF([Remedial Status]@row = "Overdue Remedial", [Date…
-
Struggling to produce the correct formula
Hi All, First of all thanks for your help! I'm trying to get the right data from a separate spreadsheet, but struggling to come up with the right way to get that data. I have a listing of staff and their recorded work time split by weeks: I'm trying to get their 'Contracted Hours' number as is recorded below. For each week…
-
How to pull information from a cell on another sheet
I am trying to search multiple other sheets for information to pull back one cell of information. The formula I was attempting to use was =IFERROR(INDEX(COLLECT({Quote Log 2024 LCI SO}, {Quote Log 2023 LCI SO}, {Quote Log 2022 LCI SO}, {Quote Log 2021 LCI SO}, {Quote Log 2020 LCI SO}), ({Quote Log 2020 LCI Quote #}, {Quote…
-
Dropdown Date Automation
Hi I am trying to automate a date being added when a dropdown value is changed, each value would have its own column for dates, I also want to be able to backdate this as I can see where previous columns have been changed, For example if a column changes from Dead to In Discussion to Live, I want all those dates noted down…