-
# Incorrect argument, bad syntax somewhere?
I've been banging my head on this for longer than I care to admit. I'm sure it is something stupid syntax error I just keep missing. Can anyone take a look? =IF([Employment Status]@row <> "Active", "", IF(AND([Date of Last Review]@row = "", Tenure@row < 91), [Hire Date]@row + 61, IF(AND([PT/FT]@row = "Full Time",…
-
Link Local Files
I believe due to the length of this conversation, the amount of recent submissions, and the amount of time it has been since a smartsheet rep has responded to this it needs to be brought up again https://community.smartsheet.com/discussion/receiving-invalid-url-when-attempting-link-share-drive-folder#comment-92701 I feel…
-
Formula to find previous Week Commencing data
I’m trying to calculate the previous week commencing data to report on. I want to be able to tally how many assets were created in the previous week using the TODAY function (so date between 7 to 13 days ago). As the date will always be Monday of the previous week. The below formula structure but I know it’s not accurate…
-
Data from one smartsheet to another
What is the best way to pull multiple columns of data from one sheet to another? In sheet "A", I have a unique number. When that unique number is keyed into sheet "B", I want to pull the next 20 columns of info associated with that number into sheet "A". I know I can use index/match, but I don't want to have to key a…
-
Counting single values with multiple criteria
I need a little help with a formula in Smartsheet, I am trying to count the number of employees who are over utilised (> 105) but some employees have multiple entries (same utilisation, so only need 1 entry in the count). Answer below should be 3
-
Create Order of Response If Text is in Cell
I have a multiple select as part of a form. I want to create a column that looks for a specific text within the multiple select and create an order of response. So if multiple forms are submitted with the item A selected in them, I would like the first submitted be an order of 1 while the 2nd time item A is selected then…
-
Creating a formula to count each selection in a cell drop down.
Hello Everyone! I am looking to edit a formula I am working on to count every option available in a cell. This is the formula I have currently. =COUNTIFS({2024 Documentation & Projects Range 4}, FIND("CC:", @cell) > 0, {2024 Documentation & Projects Range 5}, FIND("ILT", @cell) > 0) As you can see, it is only looking for…
-
Counting a Column with filled data
Hello Everyone! I am looking to edit a formula I am working on to count every cell in a column that has data filled from a drop down. This is the formula I have currently. It is looking for data in the first column that contains "CC:" but I am trying to figure out the second half that counts the amount of cells in another…
-
Filtering on dashboards?
I'm new to smartsheet and trialing it at the moment. I have a question, I hope you can help me with: I have a portfolio of companies in a main sheet and their debt issues, and related stuff in several sheets. Rows are companies/debt issues, columns are details of these. I want to collate all this into the dashboard used…
-
how to leave the optional rows out, so they don't impact the parent row completion rate
Hi Community, As displayed in the picture, we don't need any actions of the optional rows for now, but i feel like it impacts the completion rate of the parent row. The formula of the completion rate is embedded in Smartsheet , I don't think I can't change it, show as picture 2. Is there a way to make those optional rows…