-
Attachment line numbers
When I send attachments from a sheet that has many attachments it is sometimes hard to find which line that particular item came from, which would be very helpful. Is it possible to add the source line number in the automated email? And if the item is attached at the sheet level just have it say that? I'm sure I'm missing…
-
Inconsistency with FS Predecessors
This might be incredibly simple but I can't seem to find it already answered! Sometimes when I set a Finish to Start predecessor, the auto-filled "Start Date" is the same date as the predecessor row instead of the following business day. This seems to happen only about half the time. I've attached an example of me having…
-
Determining duration in Hours:Minutes
Hey guys, I have read several posts with several workarounds for calculating a value between a Start Time and an End Time where the input and result need to be in HH:MM. I have an idea and a beginning: 1. I created two System Columns. [Start Time] as 'Created (Date)' and [End Time] as 'Modified (Date).' 2. I created a…
-
Multiple If Statements
I have found quite a bit of useful information to make Nested If statements; however, they are set-up to be "if this, then that or if this, then that". What I need is: "If this is equal to this, and this is equal to this, then this" Here is what I have come up with: =IF(AND(Firm2 = {Building Code}, Firm = {Firm},),…
-
Form Search and Auto-populate values
Hello, I have the following project I would like to achieve in Smartsheet if possible. I have a master data sheet with information hard coded. The sheet has a key reference number associated with each assigned task. When a user wants to add a task into the master sheet, they have to open the form and enter a key reference…
-
Merging Cells and Exporting Reports to PDF via the App
Hi there, I love Shartsheet, but one constant aggravation for me is the inability to merge cells. In my quest for a solution, I've come across a few posts on the blog (some as old as 2015) where similar requests were answered with a generic "we'll pass this along to our developers" type response. Just curious: is this…
-
COUNTIFS parsing error
Hi, I reviewed the other countifs suggestions, but i am still getting a parsing error. I am trying to count all rows that have EBS in range 1 where range 2 has only completed and in process. =COUNTIFS({2018 TRACKER Range 1}, "EBS", {2018 TRACKER Range 2}, "Completed", {2018 TRACKER Range 2} "In Progress")
-
Time with fractional seconds
Good morning, I am using Smartsheet to track swim time which has a format of minutes:seconds:fractionalseconds (i.e. 5:00.50). I would like to see if anyone has a solution for a couple of issues I am seeing: 1. I would like to use the MIN function to look across multiple cells (swim meets) and pull the minimum for the…
-
Rollup text to parent based on MAX of another column *SOLVED
Hello- This is a look up of sorts. I have a list of files. Each time i receive the file it is logged with it's package name and date. I can MAX CHILDREN the date and it rolls up to the PARENT, however, I cannot figure out how to have the package name of the max date rollup. Any assistance is appreciated!
-
Embedding IFERROR into an existing formula
I need some help as to how to embed an IFERROR function into this formula: =IF([Group Contract Anticipated]438 = 0, "Gray", IF(ISBLANK([Deposit Due Date]438), "Gray", IF(ISDATE([Deposit Sent]438), "Green", IF(TODAY() - [Deposit Due Date]438 <= -10, "Green", IF(TODAY() - [Deposit Due Date]438 > -7, "Red", IF(TODAY() -…
