Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for February 2017
Discussion List
COUNTIF using Parent Rows Only
I am trying to come up with a formula that would count only the parents rows.
Access Cell History Modified Date in a formula?
Is it possible to access the stored date of cell's modification in a formula? I need to send email notification when a process is marked complete by a user. I see that I can view the cell history, and there is clear documentation of the date something changed, but if I could access that data in a formula in a new cell to…
Starting day of the week on Calendar
Is there a way for me to shift the first day of the week on the calendar view? I would like my week to start with Saturday and end with Friday. Thanks!
Scheduled updates
Is there a plan to allow you to delete transferred owner ship tasks under the edit function? Scenario - I create 10 tasks to "owner 1" - Owner 1 requests for 2 tasks to be transferred to an new owner - I have to delete all scheduled updates for owner 1 - re-schedule, then build a new schedule for "owner 2" Under the edit…
Getting GroupMembers of Group using JavaSDK, Smartsheet API
Hey Community! I'm stuck at a certain point in my development process. I need to receive a list of all GroupMembers of a Group in Smartsheet. I tried the following: //First, getting all groups of our smartsheet plan and storing the result in variable grouplist //Iterate through all Groups... for (Group g : grouplist) { //…
Access resource view through the API
Hi team, Does anyone know if there is a way to access the Resource Views using the API? It would be huge if we could export that data programmatically (as we can do from the UI). Thanks
Very annoying jira sync problem
Hi There, UPDATE: i tryed a other project and that did seem to work, so stories remained in the same position, disconnected from parent story or epic as intended. I think, my updates just never got synced. Am i correct when i say that when a story is allready present on the sheet, the position is not being updated, what i…
S-curves
Hi everyone, Someone knows if it's possible to make S-curves with Smartsheet to track project progress? If it's not, have you found any convenient way to make S-curves out of your Smartsheet data? I mean without copying manually the data to an excel or MS Project file. Best, Jason
Automatically Update Master Sheet Linked to Other lesser sheets
Hi Guys Now this might sound basic but I havent figured it out just yet lol. Basically I want to have the master sheet and when the users of the other linked sheets add a row of data to their sheet, it updates and adds it to the Master sheet also. Is this possible with the linked cells function?
How to Construct a Formula: If Cell is Blank Return Value from Another Cell on Same Row
How is the formula written to do the following? If the cell called "Description" on row 1 is blank, use the contents of the cell called "Keywords" on row 1.