-
Managing multiple sub projects within master project
Is it possible for smart sheet to allow to manage multiple sub projects within a master project? Each of these sub projects will be updating the tasks and data separately but it should allow to get synced on to this master project whenever change happens and visible to all. Are there any restrictions? Please let know if…
-
Sumif help
Hi, I am trying to show a rolling 6 months resource allocation matrix, so that I am able to include the resource allocation figure on the dashboard and need some help with the formula that will be required. Tried the formula in the snap shot, but it does not seem to work =SUMIFS([Resource Duration]7:[Resource Duration]23),…
-
Update Row background with API
Does anyone have any C# code to just find a row and update the row background color (highlight the row). I have it on another program, but because my rows have System Cells (Created By & Created Date) I have to completely rebuild the rows with the cells before I can apply the format. I was wondering if there was a quick…
-
Customized notification
Hi, Community member: I have already set up the notification and successfully. However, I want to add one more feature. Currently, my smartsheet has several columns: building, building name, building manager, reports delivery method (e.g., mail/email/courier) , mailing info (who should receive) and email info(who should…
-
Looking to Hire Smartsheet Help
Hi all, I see so many great features with Smartsheet, but have been struggling with having the time to learn the program in order to properly use it. Wondering if anyone with excellent knowledge of the program can offer their services to help me set up some project management and product management templates that I can use…
-
time calculations
Hi, I am trying to calculate task duration in hrs and minutes, for example Time Arrived 10:45 vs Time Left 11:57. What function/formula should I use? Thank You
-
Reminders - view sent reminders
Is there a way to keep track of reminders that have been sent? It appears they go away once sent and there isn't anything that shows they were setup/sent. Would like to be able to confirm that reminders went out.
-
Building Sheet to Alert Past Due Items
Hi All, I am trying to build a sheet that will track when items are turned in to our billing department. If the "turned in"date is past a certain date then I would like for the sheet to send a notification to certain people. The only thing is the "turned in" cell will remain blank until the date it is actually received. Is…
-
Create notification
Hi, I create the notification. I know that the receipt should be collaborator (mean the smartsheet shared with them). However, may I ask if they are set as "Viewer", can they still get notification. I have may be more than 10 people will receive notification...so, I need to know all level (editor, viewer) can receive…
-
Project Management
Hi, we currently have a few web forms, that allow clients to request quotes. These then populate fields on a smartsheet as normal. We have two challenges that I'd like to implement but can't seem to get it right. We would like to give the client more visibility on the status of the opportunities, but for various reasons,…