-
Reporting
Newbie question so please bear with me! As previously discussed, we use 3 columns to calculate the % Complete (which we then have to manually enter into the standard '% Complete' column), which are: Planned Effort Actual Effort Remaining Effort What I need to be able to do is to create a Summary Report based on the three…
-
Form is not populating to Smartsheet - Help!
Hi there, Created a Form and tested successfully last week, data entered into Form after submission populated properly to Smartsheet. This week, 'live', form info when submitted is not (making it to) populating data to Smartsheet. Any idea why this is happening? Thanks!
-
3 Conditions Formula
I want to have a flag turn red if 1. A task is considered a milestone, 2. The Planned End Date is today or before, and 3. The task is not done. The below formula is not working: =-IF(AND([Is Milestone]@row, 1, Done@row, 0, [Planned End Date]@row < TODAY()), 1, 0)
-
Gantt chart that overlays multiple projects
We are trying to see if there is a way to view a Gantt chart that overlays projects that are in multiple sheets so that we can make sure our department is not spreading itself too thin/which projects have overlapping timelines. Is there a way to accomplish this?
-
How do I change session timeouts?
My sessions keep timing out so that I have to sign in again even if it's been less than a week since I last used smartsheet.com. Having the timeout shorter than 30 days is definitely a hindrance for having an optimal experience but I haven't figured out how to change the timeout of my account. How do I change session…
-
There was an issue connecting
Hi , I am using smartsheet-csharp.sdk version 2.101.0.0. When I consume my web application on my laptop and on a UAT, everything are working fine but I am having problem in production. The utility returning "There was an issue connecting" exception. This is my code: var _smartsheet = new…
-
Internal Stock System for business
Good day, I am currently building a internal Stock system for our company, but I am running into a couple of issues. I need to assign stock to various technicians. I am currently doing this by moving the stock item row in the Technician Warehouse sheet, however, this poses a problem if on my original sheet I imported units…
-
Workflow only showing column headers not data
I have an invoice that has 2 levels of approval on it but when I get a test email from the workflow I see that it only has the the column headers on it but no way to see the actual data without going out of the view request and into the sheet. Not understanding the intent of the automated email if when you click View…
-
Populating Drop Down list from column of entries in another sheet
I would like to set up a single call log, where I could put information into a sheet that would have a cell with a pull down that would populate with unique client names (or ID's) from a column in another sheet. So, when I put a log entry in, I could have a list of clients to choose from. The next step, would be to post…
-
Mobile forms link is requesting login/free trial even though security is not enabled.
Hello, I've created a form and have the security setting disabled so that anyone can submit, from anywhere. It works fine on desktop, but if trying to submit via mobile, it is sending users to an "explore what Smartsheet can do" landing page - requesting users to either try Smartsheet for free or login to an existing…