-
Help with formula to count BLANKS in Assignee field across multiple children rows
Hi all, I'd like to count only the rows below where the Assignee field is BLANK. The problem is my formula is counting the parent rows (ECS Inbound, ECS Outbound, Flat File Inbound). I know that =COUNTIF(Assignee28:Assignee60, "") will count blanks but how do I get the formula to only count the rows in that range if they…
-
Add Years to a Date
If Term_Effective_Date = 12/07/15 and Terms_In_Year = 3 Years. What is the formula to calcuate the New Date? I need to add 3 years to 12/07/15. =DATE(YEAR(Term_Effecitve_Date2) + [Terms_In _Year]2, MONTH(Term_Effecitve_Date2), DAY(Term_Effecitve_Date2)) I am getting #NUMBER EXPECTED as an error. Thank you for helping!
-
How to design or organise a booking schedule from 3 places to be able to see on smartsheet?
Dear all, I have been trying to find the explanation but not yet found the right one. I am really new to smartsheet but reallly love to use it as it is such a powerful and smartlike it's name. I would be very delight if someone could advise me know or is there is any possibillity to generate or making a patient booking…
-
How can I get Calendar view info to wrap so it can display more than 20 characters?
I want to be able to show more than the 20-25 characters limited in the display of a calendar entry. e.g., I need to be able to show an "Issue No. (10 characters) + an Impact" which can be a list of multiple things. I would not mind if it wraps around into a second row as long as it displays all the information needed by…
-
Task Names in Gantt - bleeds off the page
I'm quite new to Smartsheet, and am really struggling with printing Gantt sheets. I have a simple project with 27 tasks, running for 6 month duration. But I can't find a way of printing the gantt without the task names being truncated (the labels that are in the Gantt part of the print itself. I have tried removing the…
-
Mapping with Smartsheet Labs
My company is a private emergency response service. We were very excited when Smartsheet Labs came along and presented us with the ability to map our clients adresses. However this feature turned out less than great due to it using Bing rather than google maps. Adresses that should be easy to locate simply wont map on…
-
Expanding a line and losing any lines beneath it.
On my Entresto PPEP 2016 Sheet-- When I expand line 46, everything beneath it is lost. How do I fix this?? Thanks!
-
How can I automatically capture date of entry on form
Hello - I've setup a webform for users to enter information about potential participants in a program. I want the form to automatically capture the date when the form is completed. I had initially set it up where I established a date field on the form but hid it from users. I thought by selecting 'Today' from the drop-down…
-
Ignoring empty lines and blank cells in Import feature, losing lines and format
I'm not sure if this is a known or new issue, but I just discovered it today, and it's not cool. While importing a spreadsheet that has 17 columns and 350 rows, I found that the file I imported into SmartSheet was not like the original. I identified two problems: Starting with the worst - if the first cell in a line is…
-
Conditional Format by cell unique based on row or column
We are undertaking major project across teams and areas and looking for a way to create a dashboard type display with ability to add spcific details. Basic requirements include. 1. We have 16 different workstreams grouped by column (overall status, staffing, planning, security, rerporting etc.). There are about 30 modules…
