-
refresh
So I have what I hope is a common issue resulting in a simple solution - when I make a change on my mobile app, the desktop "main" sheet doesn't automatically update. The only way I can think of to work with this is to remember to refresh the main desktop sheet. That requires mousing over the side bar "sheet" icon and…
-
Project Resource View
Hi Friends, In 'project resource view' currently I can see all members (project assigned members). But I don't want visulaize all members capacity at once. Is there any filter option? Reason: One month back my team member moved to other team & I am not assigning any task, yet I see him/her in the 'project resource view'.
-
Currency converter
Hi, I have project expenses in different currencies (EUR, GBP, CHF, AUD) and need to convert them all in USD. Is there a solution how I could enter fix exchange rates and after entering e.g. EUR 100.- to get it automatically in new cell / row converted in USD 112.-? I have added the example
-
Leading zeroes won't populate
We have a sheet with a column for zip code and the type of column is Text/Number. However, if the zip code starts with a "0" it won't show the leading zero. Thus we end up with an incorrect zip code entered. I'm sure it's an easy fix, but I"m stumped. Blessings, Loann
-
numbers that start with zero and webforms
I have a webform that I am trying to create but one of the columns is a number field where the number commonly starts with a 0. My problem is that when you submit a number that starts with a 0, the 0 gets dropped unless the field is formatted as text. In smartsheet, the only way I see to format a field as text is to add an…
-
Using Report builder to find past due 'Days' tasks
I have a sheet that lists bugs and it has a 'Created Date' column (not a system column, just a date column). I need to generate a report of all issues that are 'Open' and 30 days old. I can check for 'Open'. But I wasn't able to find a way to check for 30 days old in the report builder. Can I do this just using the report…
-
I'm looking for a way to calculate time of day based on predecessors.
I have a very specific need to a time intensive schedule that requires time of day (TOD) to calculate based on predecessors. Currently I have been manually entering TOD of Start Time and Finish Time in general columns but would prefer these to be formula driven. Has anyone done this?
-
Engineer's timesheet
Has anyone created a timesheet for tracking/recording billable hours towards specific projects.
-
Feature Request: Complete Update Request from within SS, or Refresh UR, or Edit UR
I send out dozens of update requests daily to people and yes some of them slip through the cracks. This is natural, as many people (myself included) set up filters for their incoming mail and don't always see them in a timely manner. As such, if I tell people to go through Smartsheet and check for their open update…
-
Milestone task child in a % complete parent roll up
I have a number of milestones (0 duration lines) in my projects. These represent decisions, meetings, inspections and deliveries. I also use % complete to communicate with our finance department, customers and project team members. These factors don't seem to play well with each other in the schedules I have set up so far.…
