-
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.…
-
#Invalid data type in a report
Hi, I want to run a report with the following conditions: Compile report on days overdue column= "#INVALID DATA TYPE" I have inserted rows with days overdue = #INVALID DATY TYPE but it doesn't pull through. Please assist. Y
-
How to prioritize timing in card view
Hi Friends, I have created a project management smart sheet & I asked team members to participate to do simple action in card view by moving from one status to another. And I have planned multiple task with them & mention the status as 'Not Started'. So team members can move the card to 'In progress' column and start…
-
Highlight changes function keep on disabling
Good day, My highligt changes function keeps on disabling. Any recommendations on how to fix this? Thank you, Y
-
Sights formatting and layout issues since the new release
Is anyone else having a problem with layout since the new release. All my Sights that were set up and published are now no longer laid out as they were with widgets all over the place :-( I've spent hours trying to fix and I am finding it extremely difficult to get them to go back as they were. Is anyone else experiencing…