-
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
-
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
-
How can I allow Viewers but prevent them from getting an update very time that i make a change to a
How can I as an Administrator allow Viewers to a sheet but prevent them from getting an email every time that I make an update to the sheet? I was not aware that these were going out to every person who has Viewer access.
-
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%…
-
Possible to link subitems when linking cell?
Hello, I am looking for a way to link a row and the sub-items of that row so our VP will have a sheet with all of our projects and their subphases/tasks while we can continue to maintains separate sheets for each project. Thanks! chrisitna
-
Embedded sheet not showing all data
I have a Smartsheet embedded using the generated code, it shows only 19 of the 23 available rows - it does this embedded on a Wordpress site, on a page of regular Html and in preview - any ideas as to why or how to fix?
-
Sync problems with Smartsheet to Outlook
Hi, I have been syncing my smartsheet to outlook very successfully. Then recently there seems to have been a bug. The calendar in outlook no longer has a title and does not appear on the list of calendars. (so i cant delete it and republish, which is how i would normally solve it) If i go to smartsheet and add the calendar…
-
Cannot see resource allocations on the resource management view
Hi I am evaluatin smartsheet resource managment view I hae assign users in 2 different sheets, I acnnot see the user allocation on the global resource managment view 1. All users are active 2. In one sheet - the users are succesffuly tracked in the user managment and in the other they dont 3. Resource managment is enabled…
-
I want to add sprint into my agile project plan
How do i add extra sprints?
-
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…
