-
Formula to calculate week number or week commencing date
I have a column of dates in a smartsheet, and wish to insert a formula into another column what will tell me either the weeknumber (e.g. Excel WEEKNUM formula) or the weekcommencing date. Does anybody have any suggestions how to acheive this?
-
Resources and Events
I have a sheet that I use for managing corporate events. Has anyone has figured out how to use it to track non-human resources to avoid scheduling conflicts? For example trade show displays, vehicles, A/V equipment.
-
Enhancement Request: Choosing which task to display on Agenda
Hi, A great way to improve your existing features regarding Sync with Google Agenda (or even the regular Agenda view) would be to allow the user to check or uncheck the tasks he wants to be synced, and the ones he doesn't. I use a lot of titles or categories for my tasks and subtasks but most of the time they are…
-
Update Request single use link
Does anyone know if there is a way to allow a recipient of a "Send update request" to use the same link more htan once to update a particular row? An installation within my organization is a single day event but can span the entire day. I may need multiple check-ins from my field tech. Today, I send an update request to my…
-
Smartsheet MRP/ERP
Hi all, Has anyone used Smartsheet in the capacity of a simple MRP or inventory management system? If so, it would be great if some examples could be shared. Especially where teams have used the Smartsheet and Google Apps integration to serve as a dynamic ERP/MRP system? I've read a couple of articles describing this being…
-
Integrate with Team Foundation Server
I use a Sheet to track features that are listed in our Team Foundation Server. I am constantly trying to keep the features on my sheet sychronized with the entries into TFS. Is there anyway to communicatie to TFS so that I can always be in synch?
-
Worksheet for Employee Referral Program
Hi Community, Would like some buy-in from the community to see if anyone has created really great employee referral program sheets that have helped their business? I'm sampling some of the templates arlready in SS, but thought I would see if anyone one else had some awesome sheets they'd be willing to share. Thanks, Kris
-
SETTING REMINDER DATES
Hello to all, I'm completely at a lost with formulas in Smartsheet because they are based on column name and location rather than cells like typical spreadsheets. The examples I find in the help are never similar to what I need, can someone help me please? We have a column for Date of Request and Due Date. Reminders are…
-
Critical Path During a Project
I can't seem to get my Smartsheet to re-calculate critical path after a critical path item is complete. The critical path should change as items are compeleted. What tells Snartsheet to no longer look at a completed item so it can re-calculate the new critical path during a project?
-
The cost of web forms
Does it cost us anything to make web forms? What is the limit of web forms that we can create. Thanks Dan
