-
How to create a formula to show last day of the month
I am trying to create a monthly timeline template, where once I set the start date for the project, the 'Billing Month 1 start' column collects the date and the following column 'Billing month 1 Close' column indicates the end of that month. From there The following 'Valuation 1' column is the result of the prorate then;…
-
Inches abbreviated as "
Hello! I am trying to write a summary formula that will count the number of valves by size within a column. My problem is that the size description recently changed from the word "inch" to the symbol " as the inch abbreviation (ex: 2" for a 2-inch valve). My old formula was: =COUNTIF([Valve Size]:[Valve Size], ="2 inch")…
-
# 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…