-
Desired target sheet for "Reference Another Sheet" is grayed out!
I'm attempting to add a reference to another sheet (via Reference Another Sheet), yet the sheet is grayed out. It is in the same workspace, and I have Admin access to the full workspace, including when I check this specific sheet. None of the other sheets in the workspace are grayed out. It has to be something with this…
-
Viewer Vs Paid Membership?
Do you have to have a paid Membership on Smartsheet's to access a link in a worksheet? Or Can you just be a Viewer and still have access or open a link on a smartsheet?
-
Counting tasks completed on time
I need a formula that says, if the "Complete?" box is checked, was the date in the Actual Completion column on (or before) the date in the Finish column.
-
Tracking Which Reviewers Have Not Submitted Forms Across Multiple Sheets
Hi Smartsheet Community, I’m looking for some help setting up a way to track reviewer submissions across three different sheets. Here’s the setup: We have three sheets (one for faculty, one for students, and one for scholarships). Each sheet lists applicants, and in each row we assign three Selection Committee (SC) members…
-
Based on frequency selected change the formula for the created date.
I feel like this should be super simple but I am just not getting it right. Based on Frequency: Daily, weekly, monthly I want to change the next due date This will be calulated from Created column and +1, 7, 30 etc added. It works single instance =IF(Frequency@row = "Daily", Created@row + 1) but as soon as I try to write…
-
Card View rearranging order
Hello. I have a sheet that I would like to use in Card View. In the setup, things appeared to be working as normal: I have parent and child rows, in the order that I wanted, and when I switched to card view the hierarchy of the cards was the same in both views. However, in my testing something has changed. Now when I…
-
Export Timeline View to PDF
Request to allow the Timeline view to be exported to PDF.
-
Have Header Row Sum All Items Within Same Column
I've been trying a few different things to see if I can get this to work and unfortunately I'm having a hard time. Right now, I have a resourcing sheet that has header rows for each team member and each week has it's own column. Every task needs to have the number of hours entered per week for the work effort. Because of…
-
Need a formula that returns a date while factoring in dependencies
I’m looking to add a couple of columns into my project plan sheets. SmartSheet already has a [Start] & a [Finish] column built into its project template, but I’m looking to differentiate between [Plan Start] & [Actual Start] and [Plan Finish] & [Actual Finish]. I renamed [Start] & [Finish] to [Plan Start] & [Plan Finish].…
-
Data Shuttle does not import times from excel correctly
Hello, We have an excel sheet that has a Start time and stop time for tracking how long items took. However, when we use the Data Shuttle, SmartSheet converts the time to a date. How can we keep this in a Time format ( 8:00 am)? This is a critical part of our playbook with clients, and we need Smartsheet to be able to…