-
Error on loading template
Good day, I need help please. I am currently struggling to open new sheets making use of existing templates, this has never been a problem before. I already tried to use 2 different browsers for this (Google & Microsoft Edge), I am still getting the same error. I am not able to do some work and falling on a backlog due to…
-
Incorrect time evaluation
Wir haben damit begonnen, die erweiterte Berichtsfunktion von RM zu nutzen, um dem Kunden anschließend einen Monatsbericht der angefallenen Stunden zukommen zu lassen. Wir wollten den Monatsaufwand mit folgender Formel auswerten: =SUMIF(Startdatum Woche:Startdatum Woche, AND(MONTH(@cell ) = 8, YEAR(@cell ) = 2025),…
-
How to "fold' up a row or section in a calendar, but not lose content
I want to be able to 'fold' up a few rows (a month) in a 12 month calendar, as we have passed those months, but I do not want to lose the content, as I will want to be able to open up the individual months later.😁
-
Smartsheet Calendar unable to update health status on source sheet
Hi, I created a Smartsheet calendar organized by Phase and then Workstream, with deliverable bars spanning duration. The goal is to create an interactive Gantt chart, which team members can update tasks on the calendar detailed side panel. The formula on the source sheet states that if At Risk is checked then Health is…
-
Metrics Pulling Help
Hi there! I have a submission sheet and a metrics sheet. I am attempting to create a formula on the metrics sheet pulling from the submission sheet. I have no trouble pulling counts, but averages are giving me some trouble.. I am able to pull the average based on 1 criteria, but no more than that. I am looking to average…
-
How to update INDEX formula criteria in a specific way?
My company has created a freelancer invoicing system using two sheets. It depends on an INDEX formula that we now need to improve, which I'm having trouble doing. Sheet #1: A database with information on all individual freelancer (aka subcontractors) contracts (aka SOWs) Sheet #2: A form-based tracker with notifications…
-
How to set up Dynamic View under new USM plan so users aren't shared to the source sheet
One of the "free" actions under the new User Subscription Model is the ability to view and edit dynamic views. I have always added users with a permission level when sharing the dynamic view but have read this isn't necessary. I can't seem to figure out how to do this. In my Dynamic View in the Sharing tab, I add a user in…
-
WBS in smartsheet.
Hi. Is there a way that I can have a dewey decimal system kind of the numbering for the items on my worksheet. I have found a solution that lets me have items numbered in the format 1.1 and 1.1.2 and 1.1.2.4 etc. But I want a system where I can have the format 01.00.00.00 and 12.04.09.11 etc; How do I make sure that there…
-
New Outlook and dragging .msg to Smartsheet Attachments
Hi Recently, my company has forced us to move to the new Outlook. When trying to drag and drop a .msg into Smartsheet it looks like it is going to drop but then nothing happens. Is this happening to anyone else? I know I can save the .msg then upload the message but that is extra steps. In the old version of Outlook, it…
-
Transferring Ownership of Workspace
I am trying to transfer ownership of assets in workspace. The email does generate however, the message keeps outputting there are issues with the transfer request AND to try again. We have tried a few times and we keep getting the same result. Please see below snip of actual email. Ty