-
Report Sorting Assigned To Column
Hi, I had posted another discussion about an issue, but I think I have another issue that might fix my previous issue if I can resolve this current issue. I was having trouble with manipulating tasks and having a view of all resources to be able to manipulate tasks. Here is that post:…
-
Highlighting Individual Cells Based On Date
I am trying to figure out how to highlight a cell based on how the status of the "actual" column is in accordance with the "Baseline" column. Is there a formula or conditional formatting rule to implement that will automatically change the color of the cell to green or red to illustrate that it is ahead or behind schedule?
-
Mandatory or Required fields to complete in a smartsheet
I have a need for users when updating or entering data in a cell in a smartsheet that they must complete some mandatory fields. A webform has this function, however on existing rows it would be ideal to have users who are given updates or entering in a new row to have to complete some mandatory fields before final saving…
-
Copy and pasting from other sources - why is it so annoying
Example I am trying to add a new 'row' via card view, in the pop up edit form that appears, I then go to paste in some key data, such as an email address from an email, the person's name from an email. When I click click, the cells are empty, if i add a space after the pasted content, its ok. What gives?!
-
Project sheet - with multiple duration columns
Hello I need to add multiple columns that allows us to input the "on site date", - "Manufacturer Lead time" - "Drawing Approval" = Drawing start Date. Screenshot as below. Appreciate any help to solve this issue. Regards Daniel
-
Automatically creating a new sheet
We have a form where new employee data is entered, which auto-populates a dashboard smartsheet. What I'd like to do is have a new smartsheet using the data from the new row in the dashboard to create a sheet (from an existing onboarding checklist template) for the new employee to track their progress. Does anyone know how…
-
%Complete Column is not showing % Sign for Parent Row
I have added %Complete Column correctly, however % Sign not being displayed correctly for Parent Row, see screenshot. Total for Parent must be 100% Instead of 1 How to correct it?
-
Unique Children
I am looking for a way to determine when a value in a child row is unqiur from values in other children (in the same parent). EXAMPLE: I have a sheet with four courses. A course may have children if it is offered in more than one modality (e.g., a row if offered om ground and another row if offered online). If it is only…
-
Drag and drop from Google Photos
Is there a way (or an add in) to drag or attach photos directly from Google photos to the attachment window in a sheet? I know I can upload from a Google drive but that requires me to save my photos to my drive. The other option is to save them to my computer. It's cumbersome to do that.
-
Why can't I merge data from 2 sheets onto 1
I'm trying to merge data from 2 sheets onto 1 sheet or even a report. I don't want to have duplicate rows w/ the same primary column though. I want all the data for the same Primary column value on each sheet to be merged into 1 row on the consolidated sheet/report. Why isn't this possible?
