Hi all, I am trying to update an existing metadata sheet in our solution build via SCC. I was able to make the changes on the sheet itself and have applied it at the template and test with an existing team dashboard. I realized after I will need to use SCC to actually make the change and then to all the retroactive sheets…
Hello. I am a newer user to SmartSheet and am struggling with creating a report showing late tasks for all users. The report I created shows only one user (me) and does not give an overview for all users. All users have assigned tasks and I would like the report to show which tasks are late, by user. I created a filter on…
Hi, does anyone know if you can change the rag colours from Red, Yellow, Green, to Red, Amber, Green, it's just a little thing but would be good to know if you can change it?
I need help creating a percentage complete formula for a Due Diligence Checklist that I am working on. The status drop down menu completion option is "satisfactory". Can anyone help? If you need more information, please let me know.
We have 23 scorecards with sample data below that we want to roll into a combined scorecard. We started avg each cell for each person and ran into the reference link max for one sheet. When we tried to create a report to tally the average score but the right fields are not showing. Any thoughts would be helpful.
Hi I'd like to ask if there was a way to save/store a value once it has been created by a formula, so that if the values that formula uses change, the value generated will stay the same i.e. the value and formula separate after the first generation. The only way I can think would be to copy the row with the new formula to…
Hi all, I've spent a few hours trying to find the solution and am about to give up. I've seen similar questions but the question/answers don't make sense for my brain today. I have 2 sheets: 1- One Sheet with a list of contracts. Some people have more than one contract, with some services included on one contract and other…
I am trying to use the value of the cell in the row above the row that is getting added to the sheet in a formula that adds and subtracts from it. The value needs to be calculated automatically upon the row coming onto the sheet. Basically I am trying something like this "=[ThisColumn]@rowAbove - [OtherColumn]@row +…
I've built out a Fee Calculator that assists our team in articulating the %allocation of a team member against a Phase of a project for upcoming projects. You'll see from the screenshot below, that the example Project runs from 4 April 2022 through to 25 November 2022 and that the Allocation reflects time against a…
I am trying to get a column that will only show me the Month in text, I am referencing Requested_date (in mm/dd/yyyy format). I am using the formula below and i keep getting #unparseable. What i trying to achieve is the following: Column A [Requested_day] = 04/14/2022 then column C [Month] = April. Any suggestions?…
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I want to use Project Name and Resource name as a criteria to pull hours worked into a different sheet. Please help.
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
i need a formula to find todays date between the start date and end date, then provide the current sprint