-
Formula trouble with IF or IFS
I have a sheet being used as a project schedule in which I want to auto-indicate the project lifecycle stage in a cell on the sheet's meta-data line. To do so, I envisioned using an IF AND statement or something similar. Below is a mock up of the way it might look in excel. Project Lifecycle Phase = XXXXXX COLUMN B C Row %…
-
Column misalignment
I have had this issue on and off for a few weeks. After using toolbar to make changes to sheet the columns dont line up with the header descriptions. Anyone else having the same issue? Regards Wayne
-
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.