-
Looking for an automated way to Pareto Dashboard data in a Chart Widget from a Report
I have large datasets with various records that have spikes and some that have only a few occurrences. Right now I have things structured in a main sheet where all the data is entered, then a summary sheet with the potential values (which need to be manually maintained to some degree) with a VLOOKUP formula to count the…
-
Is anyone else having their smartsheet refresh itself anywhere from around 2 to 6 minutes on its own
I am having an issue today with myself and multiple users where a smartsheet that is open in a tab, active or not, will self refresh anywhere from every 2-6 minutes. Even if it is in current use, such as typing in a cell. It is maddeningly annoying and I cannot currently see a reason as to why. We have a few different web…
-
Smartsheet - Logging me out / Closing while working
Smartsheet is logging me out / closing while I'm working on it. I have submitted a support ticket, but have not received any response or feedback. Is anyone else experiencing this issue? It seems similar to the issue that happened on 11/5/21.
-
Day based Reminder Workflow
Hi there ; i need your supports to create a workflow for below issue : i have a date type column named " remind date " , i want to create a send alert workflow.This workflow will start to work after 3 days later from "remind date " and will work everyday 1 time based on a hour. thanks in advance for your kind supports Erhan
-
Can I re-set baseline if baseline columns are used in formulas or conditional formatting rules
I have a conditional formatting to color code status cell based on risk level of the task (on schedule, behind or begin scheduled but not started). That works if I use start and date columns as planned and never change while tracking of progress - change only status and progress columns. If I want to trace actual start and…
-
I cannot copy data across sheets
Hello, I am trying to copy rows from one sheet to another. Everyday, because smartsheet cannot upload excel data directly into an existing smartsheet, I upload the data into a new sheet and copy the data across into a sheet which has a datamesh config. However, every time I select the rows i want to copy across --> row…
-
How to create a top five.
Hi! I've working on a dataset for a while now that essencially logs the everyday orders we receive from our clients. One of the colums records the name of the customer and I've been trying to create a report that counts how many orders a customer has requested and sort them dynamicaly as a top five/ten. It's quite easy to…
-
Return Current Month
Hi I am trying to pull specific data from a Column when its end date field = current month. I have gotten this far. =COUNTIF(EndDate:EndDate, IFERROR(MONTH(@cell), 0) = 11, IF(ASite:ASite, 1)) I am getting an incorrect argument error. Here is what I am trying to do countif a cell in Column Asite is checked=1, and if the…
-
Form not scaling properly from desktop to mobile
Hi Community, Please may I ask advice on how to improve the scaling of my Smartsheet form when it is loaded on a smartphone? The desktop version looks perfect but when I open it on my phone it is cut of on both sided and only if I turn it to landscape it looks as it should. Much appreciated and stay safe, Kyle.
-
Allocation % column calc does it work with Legacy Resource Management?
Allocation % column calc does it work with Legacy Resource Management? I added an Alloction % column but not sure how it should work and where I set team members capacity. Do we have to have Resource Management to accomplish this?