-
Independent work days for tasks or resources?
I have holidays blocked out in my calendar, however there are certain tasks/resources where the holidays don't apply. For instance, China is closed for all of February for Chinese New Year and I have those dates blacked out, but I don't want them to apply for folks in USA who will still be working. Is there a way to either…
-
Specification sheets
I need to send out a form with default values and a corresponding field for the person receiving the form to fill out. I do not want to receiving person to be able to see the sheet the form was created from. Once the receiving person fills out the field I want them to send it back to me so their entered data will stored in…
-
Rollup Calendar View
All - I am trying to find an easy way to "roll up" detail we track in a calendar view to show a summary view of the data. We are tracking deliverable assets for a marketing organization, which are organized by Target (Release XYZ) and Category (Buyers Journey Stage X). Other attributes include due date, owner, team,…
-
If/Then
I am trying to program a cell to place the text "Exceeds 30 Days". I want this to be in the cell if todays date exceeds 30 days from the Project Completion date. I managed to do that just fine. However, if there is no date in the spread sheet for the job completion I do not want "Exceeds 30 Days" to populate. How do I…
-
Master sheet overview
Hi I am currently working in a team where many projects (not necessarily related) are running alongside each other. We would like to create a smart sheet master template/dashboard that allows the project manager to manage his/her own smart sheet for the given project themselves, while all the data from the particular…
-
Need Guidance - Can you develop a Generic Project Schedule in Smartsheet
Can you create a generic project schedule in Smartsheet? For example Task 1 starts on Day 1 (start of schedule and month 1) and ends Day 30 (end of month 1), Task 2 starts Day 15 (mid-month 1) and ends Day 90 (end of month 3), Task 3 starts Day 31 (start month 2) and ends Day 180 (end month 6), etc. In Gannt View, you…
-
Importing auto numbered columns
I want to be able to import an excel file that will create auto numbered columns (date created and auto-numbered). Is this possible? What I am trying to do is as follows: I have created a template to make training quizzes for different departments. I want to make an outline in excel where employees can type in a list of…
-
Smartsheet Merge Add-ons stuck on loading
Hello Team, I am trying to use Smartsheet Merge Add-ons to print a Row in a Web Form Layout. I have completed the steps but it does not work, Merge Data is stuck on Loading as shown below: "Smartsheet Merge will create 1 document in Google Drive. This may take several minutes depending on the size and complexity of your…
-
Report Builder - Not Sorting Dates
Hello - I running reports for partners on the team to provide the user a snapshot of tasks due earliest date to latest date. When I sort A to Z on the finish date it is not working. Any ideas
-
countif red text lines
Hi, want to count "at risk" check boxes to present at a dashboard. so I thought fx=COUNTIF(Status2:Status14, "red") works, but it only produces 0 as result Any suggestion Thanks
