-
Card View Labels
When I switch to Card View I am unable to see any labels for the detail on the card. Using the example below I would not see the text units: mearly the data 21100. I would like the lable to be the column name. Is this possible? Or is there another way to set this information. Thank you
-
Sheet with Database Normalization (Primary and Foreign Keys)
Can I upvote for Database Normalization? Many colleagues and I are using Smartsheet daily and are starting to implement it company-wide. One thing we'd like to do with it is use like a database. That said, it would be great if there's some capability of assigning primary and foreign keys.
-
Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
-
hh:mm:ss format??
I am logging time spent per job using timesheet software, and the data it exports is in hh:mm:ss format. Is this date useable in Smartsheet? From this, I want to calculate a job cost. In Excel, I would do this by using the following formula: = hh:mm:ss x hourly rate x hours in a day (24) This would give me a £ value for…
-
If statement for checkboxes
Hey everyone, I have project schedules with milestones that have associated tasks for each. (i.e. releasing a drawing set includes getting it stamped, sending to subcontractors, etc). I would like to make the tasks a checklist that would populate the percent complete (instead of a harvey ball), using a formula. Has anyone…
-
Percentage Formulas and adding to SIGHTS
Hi, I am trying to use a formula based off of Counts or Sum to get a percentage of work done. Then I need to add that percentage into my SIGHTS Dashboard. I am having trouble finding an operator or formula to help me do this. Does anyone know how to best solve this issue? Thanks!
-
Is there a way to remove someone from Resource View without removing them from a project?
Unfortunately people come and go. They are assigned tasks, work on projects, etc and then if they leave, they need to be removed from the Resource View. Reassigning future tasks is acceptable, but we need the history and want to keep them listed on completed tasks. Is there a way to do this? I would rather not have to…
-
How to calculate the Actual Duration only when the Actual Start and Actual Finish have values?
Hi, I'm working on a Smartsheet of which two of the columns are "Actual Start" and "Actual Finish". I have a third column called "Actual Duration (days)". Both the "Actual Start" and "Actual Finish" columns are date type columns and "Actual Duration (days)" is a Text/Number type column. What I want to have happen is as…
-
Google form → SmartSheet → E-mail Alert
I created a google form that is linked to a smartsheet. (I had to create a google form because smartsheet doesn't have a multicheck option available for the web form capability). I'd like to use the alerts capabilities of SmartSheet so when someone fills out the google form, the answers to go the smartsheet, and it will…
-
Duration calculation issue
I don't know if it is bug or feature, but it looks strange for me. So I have sheet created based on project template. I have dependency turned on. I noticed next behaviour: If task start at weekend or holiday then duration calculated with one extra day. On attached image all tasks (except task2) have wrong value in…