-
Reporting and Function/Formula Questions
Scenario: I created a web form that generates rows in a sheet that require follow-up from another individual. Each line is assigned to someone else for follow up when the web form submitter selects them from a drop down. That person is then notified. The selected person then goes into the sheet and makes updates to the…
-
Advanced formulas: Countif
I am trying to count the number of visible cells in a cloumn. I do have a filter applies to another column and the coumn I need a count on is a date field. Any guidnce would be appreciated. Or is there a way to count the number of rows between two dates. Example 11/1 - 11/30. Thanks, D
-
"Lag field"
Unable to find the "Lag Field" Mentioned in this help screen: http://help.smartsheet.com/customer/en/portal/articles/765727-enabling-dependencies-using-predecessors
-
Account Settings/Working Days
Good morning, Just wondering if there's an upcoming enhancement for perhaps a drop-down box to select your country where it will auto-populate major holidays, such as New Year's Day, Christmas, Thanksgiving, etc, but also allow to add additional days, if needed. Blessings, Loann
-
Color Coding for Past Events
Hello! New Smartsheet user, and trying to figure out this awesome tool! Let me start with a basic question: So, we are using a Calendar of Events to help keep us on track for events that we have occuring here at our minor league ballpark. I'd like to be able to highlight events that have past already. I know in Excel it…
-
limitation on visible characters per cell (110 characters)
Hello Smartsheet Community, There seems to be from my tests, a limitation on the number of visible characters per cell. I added about 200+ characters and only 110 are visibile. Even if I expand the cell and activate the "wrap text" function, same results. Is this hardcoded? thank you
-
Conditional Formatting
How can I apply conditional formatting to the entire sheet? Some rows will automatically update based on the conditional formatting I set up but others will not.
-
Identifying Main tasks & Sub tasks / Identifying last child nodes in hierarchy
Hi All, I'm new to Smartsheet. I would like to know how could I get to know a task is a Main task or Sub task using Smartsheet APIs, My requirement is to consider all the Subtasks (Child rows) in a smartsheet for some calculation purpose. When I see a smartsheet, I can do indentation and I can recognise which is Main task…
-
Resource Management for part-time resources
Hi everyone, I'm trying to work out how to do resource management for part-timers. There are two parts to my conundrum: 1. I'd like to be able to set up resources as (for example) 80% FTE (so they only work 4 days/week). 2. I'd like Smartsheet to understand that 100% allocation for such a resource = 4 days, not 5, or 50%…
-
Gantt dependency Start/End Dates not populating?
I have a Gantt Chart with dependencies enabled. When I shift the entire start date of the project all the dates shift appropriately so I believe it's working well. I've just inserted a new row and assigned a Predecessor Row and Duration. The bar appears to the right and dependency lines are drawn. However the Start and End…