-
Equivalent to the "Link the selected tasks" from MS Project?
Is there any way in Smartsheet to have selected tasks linked in series quickly so that one will start after another? All I found is you can: - Manually type the previous row's number in the predecessor column of each task - Link tasks, two at the time, using mouse in the Gantt chart. But first you have to place the same…
-
Enhancement Request
Ability to require text input into a column for approval requests. This would allow the approver to explain the reason for approval or decline. Right now I have an update request based on the approval column, but this requires 2 separate emails. I can use a dropdown with an update request and lock the columns, but that…
-
SharePoint ideas?
Greetings, I am a SharePoint admin for our company and would really like to know how others have integrated Smartsheet into their site. Right now we have an icon with a link to the page. It would be nice to have it go to a particular Smartsheet.
-
Workflow Approval
Being new to smartsheet but an experienced systems developer I had set up a multi person approval for capital requests in smart sheet. It was quite ugly and ungainly and smartsheet was lacking features I have used in other systems. So I was very please to see the workflow approval functionality released which goes someway…
-
Feature Request-Bullets in Cells
I am sure this has come up before, but I couldn't find it in a search for bullets. I am trying to use Smartsheet for proposals and it would be so helpful to be able to format a long list of items with bullets. I realize I can create them with bullets in a text editor and paste them in, but it would be much easier to work…
-
Latest Discussion comment viewed in a cell
I would like to request that the most recent comment in the discussion function be able to be mirrored in a cell in that same row. This would allow us to quickly scan a sheet full of data and see what the latest comment is without switching views.
-
Is there a way to track the number of work days in each "Status"?
I would like to track the number of work days an item is in each status. For example, an item was in Feasibility Assessment status for 3 days and UAT status for 8 days. Is there a way to do this in Smartsheet without using a third party tool?
-
Converting UTC timestamp to Hawaii Standard Time timestamp
I've been importing data from Toggl (toggl.com) using Zapier (zapier.com) to SmartSheet. The date/times are recorded in Toggl in UTC, and I'm trying to convert this to HST (i.e. -10 hrs). My settings are for HST. The UTC format: 2019-03-15T02:43:21+00:00 I've tried several suggestions in other posts/solutions for…
-
Harvey Ball formula that reads across and produces cumulative
Hi All - I would like a formula that reads across vs vertically - here is my vertical one. I need the same thing but read about 10 columns status to then come up with an overall status meaning if there is 1 red, 7 yellow and 2 green then the overall cumulative status is red (lowest common denominator) Vertical Formula:…
-
Global Updates and using VLookup formula in it.
Hello all, I wanted to know is it possible for us to do find and replace in global update and change a Vlookup formula or to introduce a new Vlookup formula. I am trying to do that and i am not successful in accomplishing that. Please some suggestions.
