-
Auto Date updating a published report of Events List
We have an a Smartsheet of Events - tradeshows etc that we will be participating in. While initially developed for internal sharing, I have added a "publish" checkmark column, with those items checked being part of a Report, which I then Publish to our public website. I would like to include a formula in the checkmark…
-
One Click Task Completion
Hi All, In Project we invariably have different variants of: - percent complete - Task Status - Completion Date - etc What I am looking for is a way where say I tick a "Complete" checkbox and: - percent complete goes to 100% - Task status goes to complete - completion date is today - etc
-
The Power of the SUMIFS Function
When I discovered the SUMIFS statement recently it solved a problem that had made me keep things like the project timesheets for our company in a very rigid format that basically listed all projects and functions (types of work) that could be charged to. I had wanted to let people select the project they were working on…
-
Calculations in a report
I'm trying to create a report where i only see records with End Date = this week. (so not 'the coming 7 days' or something, only this week#) I have column 'Week# that shows the week# of the field 'End Date' in my sheet =ROUND((([End Date]1 - DATE(2015, 1, 1)) / 7) + 0.49, 0) in my report I defined in the 'What' part:…
-
Bug in latest version of SmartSheet
Hello Smartsheet Community, I use the formula : =[Previous Week]1 - [End Date]1 to show me my variance each week when I status my smartsheet schedule. The latested update in Smartsheet broke my formula so that when I copy the "End Date" field into the "Previous Week" field it no longer shows as "0" when th dates haven't…
-
Counting Number of Times a Predecessor is Used
Hi, Long story behind this one, I'll try to keep it short. On Smartsheet, the critical path tool isn't working for my sheet because our project has too many hard deadlines and we are not using enough predecessors; however, we need to be able to view a critical path, so I have accepted that I will have to create one…
-
Populate Row based on a pulldown selection.
I maybe shooting for the moon on this. I am building a meal planning tool. I have a sheet that has the name of the recipe and then several columns that are the ingredients of those recipeies. in the ingredance columns i have placed a number that represents how many of that ingredant is needed. I have a second sheet that…
-
Date based on another date
Hi All, I am new to this and was wondering if anyonecan help me with a date formula? I have a column 'Urgency' that uses dropdown choice - Critical, Urgent, High etc. Each choice has a set amount of time to be completed... Critical = 1 day, Urgent = 2 days etc. I have a 'Due Date' column that I would like to be populated…
-
Hours NOT adding up to correct number of days
I'm having a challenge where the total number of hours is not adding up to 1 day if the hours are equal to the "length of workday" under my settings
-
Updated cells automatically highting in Pink
Is there anyway to stop updated cells being highlighted in pink for 1 hour after they have been updated? THe reason being is because whilst it is pink it is not possible to update the cell colour to anything else which is fustrating. woudl appreciate some help on this brook
