-
Salesforce and Smartsheet Integration
Hi Everyone - Have any of you used the new Salesforce/Smartsheet integration with project plans? I see and understand how it can push and pull data as reports between the systems, but I need to figure out how to take a cell in Smartsheet (Due Date or Date Completed for instance) and map that specific cell to a specific…
-
Linking smartsheet cells to Google sheets
Can we link a particular set of cells or values from Smartsheet to a Google sheet? If yes, then how can we do it?
-
Mutiple If's in a statement
Hello, I am trying to created a multiple if Statement. If column1 contains "Milestone 1" show "30% invoiced If column1 contains "Milestone 2" show 80% invoiced If column1 contains "Milestone 2" show 100% invoiced Can someone please help me created this formula?
-
Update Request for Specific User
I have a large project sheet with multiple people assigned to various tasks. I want to send out a weekly update request, but don't want to have to select each row for each different user, as these change as a project moves along. I have several people outside my organization where update requests work perfect for them…
-
Add the ability to use array formulas?
I would like to be able to use an array formula like Excel has so I can recreate my fee estimate sheets in Smartsheet. It does not appear like Smartsheet can do this. Can you please add this capability to Smartsheet?
-
Sprint Name field
How can I get the Sprint name field to pull from Jira to Smartsheets? The Sprint field is not showing up as a field in the Jira + Smartsheets connector for me to sync.
-
Hyperlinks in Smartsheet
Is it possible to configure the Hyperlink in Smartsheet to open a local program in my computer like what we do normally in Excell ?
-
Equal = sign is not correctly calculating in formula, incorrectly determining <>
I have create a column to evaluate whether enough resources have been allocated to a task. It evaluates whether the percentage in the % Allocated column is equal to, greater than, or less than a second %Allocated column, which uses a formula to determine desired allocated based on workhours and task duration. [%Allocated]…
-
Add Trend Lines/Line Graphs to SIGHTS
Looking for a way to visualize my data in an easier way. Love how I can create trend lines for others to look at in Excel. Would love to have this feature in Smartsheet.
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.