-
Choosing a Task List vs a Project
So, I have a question that on the surface might have obvious answers but want to think through the potential implications for choosing a Task List vs a Project. In theory a Project should have a defined start and finish for all tasks. A Task List essentially becomes a "to do" list. Tell me what I might be missing please.…
-
What function can recognize a name in a multidrop down list and reference a corresponding column?
I am trying to create a sheet with the purpose of allowing a supervisor to see what crew members are currently busy and what days. This is Sheet B, while Sheet A is the list of projects and all corresponding details, like dates and crew members. I am doing this with an "Status" column in Sheet B, which scans the crews of…
-
Annual Calendar Template by Day multi activities
Hi, the default set up for the Annual Calendar template seems to only anticipate one activity per day. How can I input multiple Activities per date without adding a new row and duplicating the day of the week and date?
-
Trying to delete a large number of rows trough API
Hi I am using the Node JS SDK to delete the content from a sheet. It works fine but for a lot of rows it fails (I have tested with a minimun of 1000). I get an error that says that the request is to large for the server. I understand whats happening, but I was wondering if there is another way to clear a sheet using the…
-
Calculate Date based on Criteria in Two Cells
I need to write a formula to check a cell for a size (Small, Medium, or Large) and calculate a start date from a go-live date in another cell. If the size is small, it's 14 days earlier, if it is medium, it is 21 days earlier and if large 28 days earlier. I've go this as my starting point: =IF([Size]@row,…
-
Update on: Edit a reports without access to the underlying Smartsheet.
Is there any update on this function or a new workaround? Please see here: https://community.smartsheet.com/discussion/5916/editing-reports-without-having-access-to-the-underlying-sheet or https://community.smartsheet.com/discussion/17606/allowing-people-to-access-reports-without-having-access-to-the-main-sheet This…
-
Formulas -Automated at risk status
Hi all, I'm quite new and I'm struggling with a formula I need to apply. I need to have an automated "at risk" status (red, yellow, green) in my projects masterlist. Red: % Done is equal to 0% and the Start Date has passed Yellow: % Done is bigger than 1% Green: % Done is 100% the formula I'm coming is this: =IF([% Done]1…
-
How do i create a calendar within forms that will block off certain dates?
I have created a form that I am using to send to people to sign up for something. I need them to be able to select a date, but have some that aren't available to be crossed out. Some dates will be able to have about 10 people sign up for, so that date will need to be crossed out once that limit is reached.
-
How to create this COUNTIFS with AND/OR/NOT
I cannot figure out how to create this formula to get the metrics. I can get each individual dept metric correct using =IFERROR(COUNTIFS({(Phoenix) Project Tracker - Aerial Status}, AND(@cell <> "No", @cell <> "Complete"), {(Phoenix) Project Tracker - Status column}, AND(@cell = "Complete"), {(Phoenix) Project Tracker -…
-
Formulas for % Allocation in Resource Manager
Is it possible to use a formula to generate a percentage in a % Allocation column for use in the Project Resource Manager? Or does a percentage have to be manually entered into the % Allocation column? I've done quite a bit of research on it and haven't found a straight answer yet, but it seems as though having a formula…
