-
Smartsheet Limitations
Hi, We as the PMO team have come up with an extensive list of what we feel are limitations of smartsheets and would like some clarity around whether there's any updates coming up or if they won't be addressed Instead of listing them all here can i contact someone that can get back to me asap on each item? Please see…
-
Unable to edit smartsheet items in Microsoft Teams
Hi all, I have a client that uses Smartsheet and will be joining our Microsoft tenant shortly. I created a Smartsheet account to familiarize myself with it and connect it to Microsoft Teams. I've created a tab and connected a sheet/report and it's showing me (View only) on Teams unable to edit. I granted a co-worker Admin…
-
RYGG Ball
Hello I have looked through the list of current Formula but cant find any that matches what I am trying to do (see below): If task due date is > 2 days from current date (today) AND Status is NOT STARTED or IN PROGRESS then flag the Green ball If a task due date is < 2 days from current date (today)AND Status is NOT…
-
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")
