I've referenced the forums for help and thought someone might help me with the "unparseable" error I am getting. We are trying to do complex formulas:
=COUNT(IF(FREQUENCY([Listing Key]2:[Listing Key]20)>0,1))))
The "[Listing Key]2:[Listing Key]20" reflect the chosen cells to crunch the
I love the Indent feature and especially the CHILDREN() function.
Every time I save sheet or switch back from another sheet, my hidden indented rows completely expand & I have to re-click everything to find where I am.
What am I missing to make sure the rows stay hidden until I need them?
When I send out a manual update request it says my username via Smartsheets, and if someone hits reply, it goes to my email.
If I set up an alert and action, it comes from Smartsheet Alerts & Actions, and if someone hits reply it goes to firstname.lastname@example.org, and I never see this email.
I need to use a nested IF with COUNTIF. Is that possible? The scenario is that I need to count the number of “Red,” “Yellow,” and “Green” balls that are in a particular row in another sheet. Then,
I am new to Smartsheet and not sure how or if the program can help...I have project where I am rolling out a new program to 8,000+ locations and looking for way to leverage Smartsheet to manage. I know there is a 5K row so not sure how to proceed. Most threads talk about pulling rows out once
What kind of widget do I need to create to present basic descriptive text (background information) about a project? I’d like to pull the basic data from a sheet that is seldom updated.
The widget would be in a report about a real estate transaction. Background data I’d like to add in widget from the
I am running a report and when I do, the color of the progress bar in gantt view changes colors. One the individual sheet the bars and green, but they change to blue, orange, red, yellow, etc in the report. I cannot find any correlation to what colors they are changed to. Has anyone else
Hi there Smartsheet community,
I don't know if anyone can help me?
I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time.
Column A- Start date (20/06/2018)
Column B - End date (31/05/2018)
Column C - 20 days