-
Rolling Calendar Visual
After a few different approaches, I was able to put together a set of metrics using various formulas and corresponding visual for a rolling 12 month calendar based on the underlying data set. The data set spans across multiple years and I wanted to create a rolling calendar that always displayed the most recent 12 months,…
-
Monte Carlo Simulation
Is there a way to run a Monte Carlo simulation in smartsheets?
-
Getting sheets to talk to one another
I have two different sheets and I need them to automatically populate cell data when data is entered. I have sheet A (my department sheet) that has many columns and rows (many of which won't apply to B) and I have sheet B (another department sheet) that has a lot less columns and rows. I have set-up a column in each sheet…
-
Assistance with Formula for Faculty Course Counting
Hello, I’m working on a formula and could use some guidance. I have a list of faculty members who each teach multiple courses throughout the semester. My goal is to count each faculty member only once while summing the total value of the courses they teach—but ensuring that each course's value is counted only once per…
-
Smartsheet Control Center - Summary Sheet Reporting
Hello - Is there a way to refresh all project data through control center at one time instead of going project by project? We have an issue (reported to the help desk) where data suddenly has become blank in the Summary sheet. Doing a refresh in Control Center does re-add the data on the summary sheet, but would have to go…
-
DigitalRadius
Has anyone else heard from DigitalRadius recently? Our system hasn't been kicking off automations in control center as it should be and our contacts have been MIA for a week. They haven't shown up on standing calls or acknowledged ad hoc calendar invites. Not a peep. Is it just us or is it the company as a whole?
-
I have a formula that I cannot get right
Hi, I am taking Justin Orazio's Smartsheet made Simple course. I am in the cross-sheet referencing class. I have watched him create the formula over and over but mine just doesn't work. It doesn't give me an error, but it also doesn't count up the number of sales by the month per project manager. Can someone help me? Below…
-
Why sheet viewed - No action taken - but in Activity Log list Formatting Applied, Why?
Hi this can be mis read as action taken. WHEN ONLY SHEET VIEWED. Unless embedded formatting is doing itself (wild guess). Need to understand where/why this line of log came from. Thanks, Jinwon
-
Help generating project numbers
I'm trying to generate project numbers based on the order in which they were approved. I've tried using the countifs function but of course it renumbers my project numbers based on the position of the row. I've uploaded a screenshot to give an idea of what I'm looking for the end result to look like. Any help would be…
-
Work apps error
I have created a work app and it is viewable on my desktop but when i try to view it on a iOS device it shows me “No chart data available” which is weird cause it clearly works on my desktop. I have assigned roles to view the dashboard as well.
