-
Old Links Resurfacing on Dashboard Despite Updates
In order to maintain a consistent dashboard design for various use cases, I used the "save as new" option, generating a fresh dashboard. To expedite the process, I repurposed some existing widgets by modifying links to correspond with new forms. However, despite my updates, I eventually received feedback from users…
-
Task Date Issue
Hello, in a project plan sheet I have tasks in certain rows of sheet that are defaulting with a specific future date for no reason - there are no dependencies, it's not the project start date, so I'd like to ask what are other root causes for this behavior. Duration calculates correctly for the end date, but the start date…
-
IF / OR formula then Check a Box
I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = "Active/ Open to Accrual", 1) OR([Study Status]@row = "In Start-Up", 1))
-
Conditional Formatting (modified date not in the last 3 weeks)
I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks. So any row that has not been recently updated (last 3 weeks) should be highlighted in yellow. Is this spmething that can be done directly within conditional formatting or should I first create a…
-
% Complete Formatting in JOIN Formula
I am trying to Join various data points into one cell and when I join the % complete, it changes to decimal format. I've tried adding Value in from of the %complete, but get the same result. Can someone let me know if there is something I should add to my join formula to convert the decimal to percentage? Thank you Tiffany
-
Status
Hello, I would like to ask something about status. If I have parent and children – all status is 'in progress' or 'not started', and then I marked all children to 'complete', the parent also should be complete. How do I do this? Thank you in advance, Anja
-
Problem with Data Shuttle that is not accepting xlsx files?
Hi All, Anyone experienced problems with Data Shuttle that it is suddenly not accepting the xlsx files from One Drive anymore? From my side when I open the file itself the section "Protect/Unprotect" sheet under Review is greyed out. Could it be that this is due to Microsoft Information Protection that I'm not able anymore…
-
Nested Projects
Is there a way to have nested projects in the same sheet?
-
Using Smartsheet form to update existing sheet not working from some tablets
Hello, I have implemented a form to facilitate updates to a spreadsheet. The form functions properly when accessed from PCs. However, there's an issue when attempting to update the sheet using a tablet, which our operations team uses on the shop floor. Strangely, when I used the same account on a phone, the form worked…
-
Version History and Sheet Enhancements
It would be great if Smartsheet could do the following within a sheet: Hide Rows within a Sheet Freeze Rows Have the ability to access a previous version history of a sheet
