Im attempting to make something that AUTOMATICALLY creates a way to change a percentage...
our table goes like so.. 45% and up is 8% on another line anything between 44-41% is now 6% and 39% to 35% is 4% anythign less than 34% is 0% ..
This is my equasion I think im on the right track but it does
So, there are plenty of ways to view the data in a sheet, and to regulate access. My issue is when a sheet contains sensitive data, and that you want to give view and update access to only a few of the columns via a report. A good example is a column for internal comments and one for
I have a project sheet where i added an actual start and actual finish. I also added an "actual duration" column, which is a calculated field. In that column is the following formula:
=NETWORKDAYS([Actual Start]2, [Actual Finish]2)
The problem is that in some cells it is showing a huge value.
I can't find any discussions on this.
I'm looking for conditional fomatting based on two of the three System columns: Attachments and Comments. These are not available today when trying to add conditional formating to a row.
For attachments, I would like the criteria based on:
- Changed: If
I would like to request a new functionality of adding row-level alerts. I know there is a discussion where Travis mentions workarounds, adding very formula-dependant sheet-level alerts to simulate row-level alerts.
But this is a work around, and not a functionality. So this is an official
I am able to figure out the fomula to count these items individual but i am running into trouble getting the correct format if i want to count # of clients that came in based on today's date at the specific location. Any help is greatly appreciated.
I want to use a filtered view in a reminder sent to all users of the sheet. Two other alternatives if that cannot be done would be to create a reminder in a report, or to stop the SmartSheet from displaying in the standard reminder.
The goal is to send a reminder to team members that shows just
I am trying to filter dates in report buider. I am using WHAT which gives me the option of manually inputting dates between . But when i use the run it doesnt filter to the date crieria I have used.
I have tried to use the WHEN column but it I lose all the rows then and I cannot see the relevance of