Discussion List
Smartsheet Benutzergruppe in Berlin
Hallo liebe Community! Am 21. März findet unsere nächste Benutzergruppe in Berlin statt! Online Fashion Store Trendyol berichtet, wie sie Smartsheet nutzen, Prozesse optimieren und maximale Wirkung erzielen. Hier geht es zu mehr Infos und zur Anmeldung: https://bit.ly/49ZfKKY Wir freuen uns Sie!
Formula for SUM of cells that have data based on an IF formula
Hi there, I have some cells that display a dollar amount depending on what drop down option is chosen in another column. I want to do a sum of these dollar amounts but the usual SUM formula is showing zero. Do you have any tips here? Thanks!
Completion date with last 30 days formula
Hi, I am needing a formula to calculate how many rows have a completion date that is within the last 30 days. I have tried =COUNTIFS([Completion Date]:[Completion Date], ">=" & TODAY() - 30) but it comes up as #UNPARSEABLE Any ideas? Thanks in Advance
Sum of Children While Maintaining Column Formula
It would be incredibly helpful to allow for the sum of the children on a parent row, but maintain the column formula.
Run Log error in Bridge / Smartsheet integration
Hi - I am trying to follow the instructions on how to copy partial rows to another sheet using a Bridge workflow (https://help.smartsheet.com/articles/2482720-copy-partial-rows-using-Bridge). I'm not getting very far before hitting a run log error. I've included the error and the step where it's occurring. I've tried using…
Dashboard Charts - Secondary Axis, additional data points, target line
Hello - It would be nice if we could add a secondary axis to charts to show additional data points in one chart. Attached is an example of this ability in excel.
Can Smartsheet Forms handle more than 100 questions?
Has anyone here made a form that had more than 100 questions, many of them with logic? I know there are limits to logic conditions and before I do a lot of work to build a form I want to make sure Smartsheet is strong enough to handle it. My other option is jotform. Thank you!
While using blueprint, not able to retrieve the project name
Seeing this "[blank naming tags]" in the Project Name field in control center homepage even though a name is provided in the intake sheet.
CountIF issue
=COUNTIF({CBG Cold Spring, MN Items List Range 2}, {CBG Cold Spring, MN Items List Range 1}, >DATE(2024, 1, 1)) Hello i am trying to find non blank in a column based on the criteria that is after 1/1/2024 and this is not working. It says incorrect argument set.
Survey- how do you track projects over multiple years?
Hello Community, I am trying to track projects over multiple years, but each project varies in length. My concerns are hitting the max number of columns and not having to do a bunch of manual set up at the end of the year. Has anyone else had this issue? How did you solve it? Thanks, Ashley