-
IF(ISBLANK with IF work on one Column but not the other
Hello, I was looking all over the Community page and I was able to find the help I needed to make my statement work but when I changed the column in the statement it would stop working. I was hoping someone could explain the difference to me. Below are my examples. 1. Working statement =IF(ISBLANK(task@row), "Not Started",…
-
Using a nested HAS formula within a COUNTM?
Hi there! For the life of me I can't figure out this formula! So here is the scenario. I have a grid with a dropdown multi-select column type with different organizational shared service options (e.g. Knowledge Sharing, Project Management, IT, Applied Learning). On a separate grid, I am trying to identify the number of…
-
Update cells via form or secondary sheet?
I have a sheet of contracts with 30 columns (status/progression/etc). The columns are updated by different people in different departments. Is there anyway to create a form that would have a dropdown of the contract ID and then the cells I need updated? If that isn't possible... Is there a way to make an automatically…
-
Locking or freezing the TODAY() formula
Good day all, I've looked around in the community about locking or freezing a current date, but I'm still having issues. My goal is to lock a start date that's triggered by entering a X and have that current date freeze until the x is removed. When an X is entered in the Visit column, that triggers a start date to…
-
How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cells
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focused data, data that should not be managed on an International sheet that already has 85…
-
Formula to return multiple contacts based on multi drop down options
Okay, I'm trying to write a formula to automatically populate a contact based off the information selected in a multi drop down. I have a separate sheet that lists the appropriate contact for each item (Sheet Name: HR Contact for Reminders). In the sheet "Seasonal, CDL, & Missing Requirements", I want the "HR Contacts for…
-
Track time an item was open (active)
I have a date stamp column already in the SmartSheet. When a new row is added, a date and time are assigned. What would be the best method of tracking and reporting the time duration between when the row was added and when it was closed ? I have ideas but have found it makes most sense to run it by one of you first.…
-
Formula-Reference another sheet and see the column rather than(SheetName Range #)within the formula
Hello, I have a formula I am using on one sheet. The sheet is named "Mark" since he is the Point Person. =COUNTIFS([First Contact Year]:[First Contact Year], "2020", [First Contact Month]:[First Contact Month], "Jan", [Point Person]:[Point Person], "Mark") I have another sheet named "Summary - 2020". I want this exact…
-
Docs sheets in Smartsheet
Hi Are there any plans to introduce documents alongside sheets in Smartsheet? (like Google Docs and Google Sheets in Google, and Word and Excel in Microsoft) Thanks Cheers Richard
-
Formulas not showing in new rows
Hi, Not sure if this is a new issue but formulas in sheets aren't showing in new rows if there is a parent row below it. The first attachment shows how the sheet is setup and a number of columns have formulas in them. If I add a row between Test 3 and the Applications Confirmed parent row, it won't pull the formulas down…