-
Include "TIME" Function in the "All Functions" tray (in addition to any other omitted functions)
Years back, I learned the functions of Smartsheet by reading, reviewing and then testing all the functions from the "All Functions" tray. However, last night when hitting = and T, I saw "TIME" as a possible function. Not sure long I've been missing this from my tool kit, or what else could be missing. I checked both the…
-
CountIFS based on rolling FY and item.
Hi Everyone: I am trying to count how many of X has been completed (based on completion date) in the current FY based. Ideally I'd like the count to automatically update what the current FY is. I think this should be a simple formula, but for some reason, I'm at a loss. Thanks in advance for your help.
-
Query Formula Help!
I am currently creating a search query that will allow anyone to search for a name and get the corresponding information. For some reason, when I try these different formulas, I am receiving the error message even if the name is correct. I've included my references in the formula as well. Can anyone help with this? Current…
-
Evaluate a date and return week #
I have a date input in a worksheet and need to somehow lookup what week # the date falls in. My weeks begin Monday and end Sunday. Screenshot of 'Date Range' worksheet below. So if my input date in a separate worksheet is 03/15/24 I want to return 11. I am using this in a 'LookUp' worksheet. Screenshot of 'LookUp'…
-
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…
