-
Column widths should be lockable
I'd really like to have the ability to lock a column width and/or have the column remember each person's/device's last width setting. See: https://community.smartsheet.com/discussion/87852/lock-column-width I work with several sheets multiple times a day that I share with a co-editor. Because of differing screen sizes and…
-
What's breaking my task dependencies when using elapsed day duration
Hi I ran into an issue today where my smartsheet timeline was updated without any user's input and several dates were changed cascading to the entire timeline. I tracked it down to several tasks and started correcting them, realising that there is some issue when dependencies are using regular "day" duration and some are…
-
How do I get the exact number of Years based on the date column (no more rounding up)?
Hi there! Can anyone kindly please help me with this - I'm new to SmartSheets and having trouble working out formulas… In one column I have dates that Volunteers started volunteering with our company. The second column I used the following formula to get the number of years that it totals: =YEAR(TODAY()) - YEAR([Vol Start…
-
Web Version Loads The Same Sheet
Hello, With the new update I'm experiencing an issue I didn't have before. I use Smartsheet web version because I typically work with 20-30 tabs open and it makes it easier to use than the app. Since this new update, every day when I open my laptop I am prompted to log in (as usual), but when the sheets load they all open…
-
Smartsheet Shared as Admin but User Cannot Input Data
I have shared a Smartsheet content to a user within the organization and the access provided is "Admin", however the User is unable to input any data. The same access has been provided to a different User and the behavior is different, user can edit any lines. Is there any particular access that I need to check to ensure…
-
Salesforce integration
Hi all, Newly "back" to my organization, Smartsheets is a new tool they use. I have taken a lot of the video training, but I haven't found one to understand how Smartsheet and Salesforce work together. Can anyone guide me or post where I can find the training?
-
Can I count cells between number thresholds if the cell also has text in it?
Hello! I'm currently creating formulas for a gift register to document the price ranges we have and how many are in each category. My categories are: £0 - £50 £50 - £100 £100 - £200 £200 + However, the formulas aren't pulling back all the data accurately because some of the cells include text too like 'less than £500' or…
-
How to Preserve INDEX Formula Data When Archiving Row?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
-
I can't get any help to fix my forms.
It tells me this below and my QR links stopped working and there is no customer support even though i'm paying for this. formName: ajax formAction: fa_getLicensing serverStatus: false serverStatusText: CriticalException errorCode: 48
-
Merged: We need a way on a Project Schedule to delineate certain items can be completed on the weekend without turning it on for the whole sheet
This discussion has been merged.