Hi, I am trying to link the cell to other sheet, once the data is filled up from the web form. The problem I am facing is, whenever the form is submitted & the data is posted on my sheet, it is being …
Okay first off I did not write this syntax I copied and pasted from another post. It works to a point but I need it to be a little more detailed and I cannot figure it out. Here is the syntax: =IF(Sta…
Is there a formula to make a column with duration values like 1:30, 2:45, 3:15, etc etc (only ending in either :00, :15, :30, and :45) to 1.5, 2.75, 3.25 hours (again, only ending in .00, .25, .50, an…
Hello, I am using smartsheet for my master project plan and I repeatedly run into one issue, my project Duration count roll up is inaccurate. I have attached a screenshot to provide a better understan…
Hi Smartsheet Team, We have group mail via gmail in our company. Im using it to Assigned To contact list to notify them all for any changes. But unfortunately it doesn't work. What could be the proble…
Hi, I created a project smartsheet with gantt dependencies in duration of "hours" for an important project that lasts one day. I was wondering if there is a way to create a gantt chart that only displ…
I was updating my sheet yesterday and payed no attention but this morning I've noticed that all of the task names on the Gantt chart are gone and I can't seem to find a way to get them back. Any ideas…
Hi friends, I will try and explain what I am trying to achieve: I have an issue tracking sheet with columns effectively divided into 3 sections: 1) Originator raises an issue on a webform, on clicking…
Hi All, This is probably something easy to do, but I'm still a little new to SS administration. I have a issues log that has a "Assigned To" Column (using contact list) and a "Modified Date" (system).…
Hello, I'm trying to figure out how to get totals by specific month. There are 3 columns I'm trying to pull data from, a monetary column called "Unit Price," a dropdown list column called "Produced," …