-
Count cells containing string
I'm trying to create a tally of the number of rows where a specific column contains a string. For example, the contents of a cell = "6-1, 6-2, 7-2" and I want this to be counted as 6-1, as 6-2, and also as 7-2. If this row were to only have one designation, so cell = "6-1", I could do this easily with COUNTIF. But although…
-
Formula to count check boxes in row one of column
I have a questionnaire with multiple columns. Responses are either check boxes or comments. I want to summarise the total check boxes in each column. I can add a column and write a formula to total the checkboxes, but the error message "#1 or 0 expected" appears when the formula is in the same column as the check boxes.…
-
How do I format a column for phone numbers?
I would like to format all input numbers to have the same format (xxx) xxx-xxxx
-
Sending alerts in advance of start date
Hi all! I need to schedule a row-by-row reminder 8 weeks in advance of the row start date. I've looked at the 'alerts' feature at the bottom of the sheet but it looks like the maximum I can send a reminder in advance of the start date is 14 days. Is there a work-around here? The sheet I've created is a marketing calendar…
-
Fixed duration in the Gantt chart
Hi all, I'm evaluating duration time of every tasks. In the sheet, I set a duration time, a start date and the end date is adjusted accordly. If I want to change the start date, the end date will be updated and vice-versa. It's fine. However, in the Gantt chart, when I'm touch a gantt bar to change the task start, it's…
-
Smartsheet Charts with parameter
Hello Community, Anyone familiair wiith the charts via https://smartsheetlabs.com/ ? Is there a way to feed a chart with data without having to make a new sheet or report for every chart ? Example: - within 1 sheet I have a project which has several taks, each with planned hours and actual hours. - in a separate website, I…
-
Web Form Linked to Multiple Smartsheets
Hello, I was wondering if it is possible to create a web form that is linked to multiple smartsheets. I am working on a project for a friend. He is doing some research, and wants to know what things people have tried out and have ratings for these (multiple items on the one form with ratings for each, under each item). To…
-
Conditional Formatting
I have a question that someone may be able to help me with. If I have a column called Finish Date. On line 5 - I enter a date that my customer wants project to be finished On line 4 - I have a automatic date that is from a predecesor based on finish date so that it populates automatically depending on the tasks completed…
-
Enhancement feature - Merge Cells functionality
Wanted to start a thread for an enhancement feature to try and push this up in the road map prioritisations. For such a simple and standard feature in tools like Excel and Google Docs it has become such a barrier during the process of trying to migrate exsisting documents form the above tools to Smartsheets and now is…
-
Coordinating multiple projects and sharing sensitive documents selectively
I have 5 vendors working on a project. All five vendors have tasks which are significant projects in their onw right. There are interdenpendencies. I want to coordinate the project in a way that there is one gantt chart for the overall project which all vendors and their teams can see, their project managers can edit and…