-
Modified Date in Formulas
I am trying to use the auto-populated system column "Modified" in formulas. Specifically, I am trying to create a "Modified Helper" column that takes the "Modified" column date alongside the time, checks if it is after midnight, checks which shift it was logged under, and log the auto-populated "Modified" date to reflect…
-
VLookup returns nothing for assigned to requiring multiple answers
Hi All, I am working on a project plan where I have a drop down that I can select multiple roles to assign a task to. The Vlookup references a contact list of single role, single assigned to. When using a simple vlookup formula, it will give a single answer where there is a single assigned to, but what do I do to make it…
-
View Cell History not updating
I'm having an issue where the View Cell History is not updating as cells are filled and cleared. The Activity Log still updates as normal, but due to some people accessing the file not having a license, the Activity Log alone is not sufficient. I've tried refreshing the sheet, and the 8th is the last day that was correctly…
-
Advanced Search needs row number
When performing an advanced search, the search should return the task (row) number. The only way to determine the task (row) number is to edit the returned search item.
-
A unique number based of off criteria
Good morning all. I have a challenge for everyone. I need a unique number based on the previous rows unique number that can then be influenced again by another criteria. The "Number" MUST always increase. The "Identifier" column is the column in question. I have tried multiple was to populate this but I either get a…
-
Project Intake management
There could be a very basic and simple answer to this, or a complicated one-I hope its simple!😀 We have around 50-100 projects at any given time and we need to track and report on various deliverables. I have set up Intake Form- Intake sheet-Portfolio tracker, as well as project plan for each project. The Intake form is…
-
Image import from Excel/Sheets
When importing a spreadsheet from Excel or from Google Sheets, it would be SO helpful to have embedded/pasted images come into the new smartsheet as attached images. Use example: Users copy/paste screenshots into a Google Sheet being used as a bug tracker, because Google Sheets makes it very easy to do, but then they're…
-
Request for Flexible Editing Access for Free Members on Project Plans
Hello Members, I hope you’re doing well. We’re a small team of six members with a Business License — three licensed admins and three free users — using Smartsheet to manage and track multiple project plans. As admins, we create new project plans directly in Smartsheet and import some from Microsoft Project. However, our…
-
Published Sheet - Users Unable to add Attachments
I have a sheet for which I've provided a publish link to many unlicensed users. They use the sheet to attach files to rows. This has been working as expected for multiple years previously, but today, we've discovered it will not allow them to attach files to rows and they're met with the message "This action has been…
-
User unable to access workspace - nothing changed?
Hi all, I have a unique problem that's developed today: I have an admin-level user who cannot access the workspaces or attachments - a locked display shows. This person can access info on the orange reports, but not on the blue reports. Between yesterday when the user had full access, and today - nothing has changed with…