-
Linking cells that are dependent
This is going to be a tough one to explain, and I'm not sure if it's possible. That said...: Endstate: For a finance-based sheet ("Sheet 1"), I want one of the values from a user's form (Amount USD) to populate in another sheet (Sheet 2"). Problem: There is a debiting manager (losing money) and crediting manager (gaining…
-
Posting URL's to your project plan in Google drive.
Hello Is it possible to post a URL to your project plan in Google drive in your project folder? I like to organize all of my project documentation or URL's to it in the same folder. Otherwise I will create a Google doc containing the URL I guess? I did see a Smartsheet Sync add on for Google drive I don't know if that will…
-
Enhancement Request: Ability to use Rich Text or HTML format options for Comments
I would like to request the ability to use different format options in the comments window. We are currently able to add plain text comments but it would be nice at times to use a different format like Rich Text or HTML.
-
Report - Share Access
I would like to be able to run a report on the Share Access on all Smartsheets that I own & as well as on Smartsheets for which I am an admin. (e.g. SS name, user name, share permission) I understand this is possible but only by requesting a 'Sheet Access Report' from the System Administrator…
-
Automated approvals
I have set up a workflow with multiple paths I come to a stop when I get to Decline. Here is my issue We set up an invoice approval flow The 1st step is to have an internal review and the 2nd is to the customer for approval. When there is a decline on the 1st step the next step is to request an update to revise the…
-
calculate minutes a delivery is late
I am wanting to create a formula whereas I have an expected delivery time and actual delivery time and need to determine how many minutes the delivery was late. Does anyone know what formula to use in Smartsheet?
-
Primavera
Hello Everyone, Does Smartsheet can work or import primavera (enterprise project portfolio management software) ? Thanks for you help Olivier
-
Cell Linking Issues
Hi all, Is anyone else having issues with cell linking? I can no longer get it working.... It was all fine until about 4 weeks ago and now nothing will link?
-
SUMIFS based off Status and date?
I am building a counter for a team where they do a simple web form to say which task they did, and how many times they did it. There then needs to be a dashboard that then has a sum of that type of tasks completed during the current month, and the previous month (seperate). The FormData screenshot is the Grid that collects…
-
AvgIF(Children)
Is there a way to get an average of selected cells (all the Children of a column) only if they are not blank? I am stuck and trying to automate the functions as much as possible. Thanks a ton in advance!
