Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Discussion List
SUM of consecutive cells until blank cell is reached in the column
Hi, i am trying to SUM any given number of consecutive cells in column A and need it to stop once a black cell is reached. For instance The SUM will be column A, row 2 to 6 (7 is blank) and I am wanting the SUM to display in column B row 1. This will repeat throughout the sheet, but the SUM result will always be column B…
Card view - spanning lanes
Hi Is it possible to have some fields in the card view span several lanes? Thanks, Galit
LOOKUP function return value
Hi Smartsheet team, Thanks for getting the much awaited LOOKUP function supported in Smartsheet.. This is a great add !! I see a problem with LOOKUP() return value when the lookup_value is not found in lookup_range. It is returning Empty string instead of an Error. Because of this, I am not able to distinguish between key…
Reports in SmartSheet
I want to create a report that summarizes information on my smartsheet. I don't want it to list individual line items. Is this possible? I am trying to mimic something I am doing in Excel with pivot tables and tables. If it's not possible - does anyone have recommendations for reporting plug ins?
Requesting recurring daily Backups
Hi, Is there a way to request recurring backups on a daily basis? Or can the recurring backups only be done Weekly?
Report on today and next workday
I'd like a Report that shows rows with the Date field from today or the next workday. That is on Monday - shows Monday/Tuesday Tuesday - shows Tuesday/Wednesday ... Friday - shows Friday/Monday Saturday - shows Saturday/Monday Sunday - shows Sunday/Monday My sheet is very complictated and starting to visibly slow down so…
IF Statement
I am currently working on an IF statement for RYG. I currently have a statement that turns green if the task is not on the due date and in the future. I have it turn yellow on the due date and red when past due. I am trying to get the IF to work adding grey to the mix that if the column done (checklist) is marked that it…
Entering Address Information
One of our users has a sheet that includes an Address field to store mailing address information. They have created this as a Text/Number field an enter multiple lines of data (c/o, address line 1, address, line 2, city/state/zip). The same Address information applies to mutliple rows of data, but currently they need to…
Collaboration outside our organisation
we want to collaborate on certain rows but not all rows with an external partner. is there a way we can do this without sharing all the rows in a Smartsheet?
Formula help - set values for current user and date when check box checked
I have a checklist I am building for a department where they will be primarily mobile users so I would like to reduce the thumb typing as much as possible. I see where I can use test the value of a checkbox and make it do things.. but what I want to do is get the current date and current user. So that when someone clicks…