-
Formulas and Calculations
Duh!! I figured it out. It was simple. Dennis
-
Customizing Gantt Charts
I am brand new to SmartSheet and my team is primarily interested in finding a Gantt Chart / Timeline maker. I'm hoping the community can help me figure out the following: * Is it possible to make the gantt ribbons flat, without arrows? * Is it possible to show the task name on the ribbons? * Is it possible to make the…
-
% Date calculation
Hello, I need to create a % calculation for the number of dates meeting a 'launch' date. What is the best formula to use for this? I will have a long list of dates and I need one column to calculate how many of them are equal to or less than a launch date (25/03/2021). Any guidance would be greatly appreciated. Thanks,…
-
Working Days Counter Based on State, Lock # when completed
I am trying to create a counter that counts the number of days in work of a task, the counter only counts the days in work when the Scrum state of the task changes to sprint . I want the counter to stop counting when the state changes to done and lock that number of days in work (days in work from sprint to done) and still…
-
Auto Assign a Predecessor in Gantt
Hi, I have a series of standard processes that have the same dependency and predecessor data each time. I have the primary column as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.). If pre-assembly is selected, for example, I always want it to…
-
Adding Rows in a sheet
When adding rows to a sheet, why does the Dashboard graphs not recalculate the graphs with the new rows? Seems the only way to fix this is to back in the graph and select the new data rows. Am I doing something wrong? Thanks David
-
Usage metrics
Hi Smartsheet community, I am trying to create an app that fetches usage statistics/metrics for a given smartsheet account (like number of sheets or items created, edited, opened, etc), but couldn't find any API which could do the same. Webhooks is one way (not exactly), but that also we can create per sheet (not all the…
-
T-shirt size icons for visual icons?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
-
Is there voting functionality within smartsheet?
I'm looking to see if there is a way to vote within a row. We're doing a hackathon to collect ideas for future development which will go to a panel - we'd like the ability for multiple people to vote on a single item. Any suggestions or workarounds anyone has used in the past?
-
Formula
Hello everyone, I'm new to smartsheets and so far my experience has been positive but I'm heading into areas that go beyond what I have learned so far, I used basic formulas to do counts using =SUM, and =COUNTIF but I only have been able to use it to do basic counts. I need a formula that will look at at multiple columns…