-
Search using wildcard* not locating content in a sheet
Hello, Today a user asked how to make the searches in a sheet less restrictive. I offered the wildcard as a solution and as we were walking through the search it found 0 results. Within the sheet I have a column with a customer part numbers including revision example: 111-111111_RevA. I perform a search for the part number…
-
RACI Template
Hoping someone can help steer my in the right direction! IN the project managemet tools there is mention of an RACI template however when I log in it does not seem to be there? Am I looking in the wrong area or is this some secret enterrise level only template... Thanks Nik
-
sumif date is today to end of month
Trying to write a formula that doesn't need manual updating that basically sums a total amount for file that have a closing date from today to the end of the month. Seems like it should be fairly straight forward but I cant get it to work. The sheet has parent rows but i want to include all rows in all parent rows in the…
-
Nested IF AND & OR
Hello, I'm looking for a good formula to collect the number of remaining days to work. This works fine: =IF(OR([Assigned to]110 = "User1", [Assigned to]110 = "User2"), [Closing date]110 - TODAY(), "0") but If I want to add one more condition like at row status it doesn't works: =IF(AND((OR([Assigned to]110 = "User1",…
-
Slow Response Time
Hi all, Is anyone else struggling with slow response times from Smartsheet. I have around 40 sheets that i work on, and 1 tab open. Even simple tasks like moving the mouse and clicking on a cell or an option is taking around 30 seconds to complete the action. I have tried this in empty sheets and still finding the issue so…
-
Programme RAG
Hi All, I have a roll up sheet for the programme of work, each line is a project that is being worked on or queued for work. Each line has an Overall RAG called ''Overall Status''' for the overall project and I have a metrics table which states the Programme RAG, currently this RAG for the Programme would be manual, i…
-
Microsoft Flow - Inserting a new row on a sheet with Dependencies enabled
Hi, I'm currently trying this out to see if we might use it more widely in my organization. I'm trying to insert a row using Microsoft Flow, but I am receiving the following error: * End Dates on dependency-enabled sheets cannot be created/updated. Please update either the Duration or Start Date column. Based on another…
-
Automated task status in a project plan
I am building a project plan and would like to have the "Status" to be automated based on the % a team member fills in for a task. I've tried several of the IF OR and IFAND statements and they work partly. I can get the "Complete" and the "Not Started" to work but unable to figure out the "In Progress". When I try to nest…
-
Update requests not updating
Hi, Please can somebody help me with what seems like an easy process of requesting an update, but is not working. I have done selected the rows and cells that I require updated and sent them to an external stakeholder as per the documentation and videos. The first attempt did not actually update the Smartsheet, I had to…
-
Auto-Number Fields on Form Creation
Hi Is there a way of Auto-numbering Fields during a Form creation? Put simply can you automatically number questions 1, 2, 3 etc? Or can this only really be done manually by changing the column titles? i.e. 1 - Where do you live? (for example) Many thanks Nick