Hello- I am managing a project in Smartsheet where I need the ability to conduct ongoing monitoring of resource hours for tasks per week. The use case is for the PM to use this info to ensure the estimated times of tasks assigned to a given individual don't exceed that person's availability cap (That data is stored…
Hello! I'm trying to figure out a formula to do the following: 1.) Display percentage complete of tasks marked "complete" within a child group, at the child top level 2.) Display percentage complete of child groups in the parent row. Note that I am not using dependencies, and am using an independent "% complete" column (I…
Hello- I'm trying to create a formula to populate a field with a fee amount based on the designated country group in another column. Essentially, I'm trying to say: If country A, return $125.00 If country B, return $160.00 If country C, return $125.00 If country D, return $160.00 If Staff/Comp, return $0.00 What I came up…
Hello- Our team uses an existing O365 Outlook calendar to track events. We'd like to tie in a smartsheet to that existing calendar, but the only way that it seems possible is to create a separate calendar just for Smartsheet. Is there a solution where I can add smartsheet events (start/end date) automatically to this…
你好,我开发了一个表,tracks new registrations, with info like name, program, registration cost, revenue totals, etc. I want to create a weekly report that includes any new entries added to the sheet since the last report, but also to include the total financial sum of those new entries on the sheet. If I…
Hello- I've created a filter for a sheet, which does not appear in the default filter drop-down under "Share". Below are screenshots of the filter, the top menu filter drop-down, and filter option in the Share section. Could someone provide some advice on what might need to be changed?