Discussion List
Record a Date when status changes
I have a set list of statuses that I want to keep track of and collect durations. For example, when the status changes to Sent to Lab (Ongoing), I want it to record a date in the Sent to Lab column. I feel like it should be an easy thing to do I just can't get it right.
Can I add Task name + Resource name on Gantt tasks?
This discussion was created from comments split from: Text in Gantt chart.
Configure availability for an individual. Apparently it exists, however I don't see this option.
Some of our people work 5 days per week others only 1 or 2 days. How do I set availability for each team member? I found this link describing what I need, however I don’t see those menu items. See attachment. Which Smarsheet icon do I click for Settings > Account Settings > People? On the bottom left corner of my…
Cell Link Reference not auto population new inputs from the source sheet into destination sheet.
I don't know what's going on but Cell Link Reference not auto population new inputs from the source sheet into destination sheet. I select the first cell of the column where I want my data pulled into and enter the column range from the source sheet using the cell link reference. However, every time I enter new data in the…
COUNTIFS formula for two Ors and one separate?
Hello, I would like a formula that reads COUNTIF the RAID Item Type = PMO or RAID Item Type = Change Enablement or if the Program Display box is checked. My formula currently works with the OR statement for the two RAID Item Types, but stops working when I try to add in the Program Display clause, as that is a separate…
Automation to change a cell value
Hello - I am trying to use an automation to change a cell value. I was originally triggering the change with a cell populated by a formula pointing to a cell with a cell link from another sheet, which I understand won't work. Is there a workaround for this? More detail: I am using smartsheet for headcount tracking in my…
Task Health, error applying formula
Hi All I have 4 columns on a sheet which are checked boxes, when they are all ticketed, i want the task health column to change to green. I am using this formula and applied it to the task health column but I am getting a circular reference. Where should i be applying to formula or is the formula wrong?…
Accumulative date formula required
I require a formula that calculates the PRODUCTION PACE of completed builds to number of days in the working quarter. Currently we are calculating the pace off the total number of days in the QTR (eg. 61 days from April to end of June), but this is not working for us as the pace is too larger for the actual pace we are…
Getting error when trying to use Assume-User functionality to fetch the data of all users.
The Admin account is unable to fetch data for other users incase of the developer account. When we try to use the Assume-User functionality to fetch data by impersonating other users, with the help of an admin account and Oauth2 session, we get the following error. { "errorCode": 1030, "message": "You are unable to assume…
Smartsheet and Teams - open within Teams
This discussion was created from comments split from: Smartsheet Integration for Microsoft Teams apps consolidated and permissions reduced!.