-
#INVALID OPERATION with INDEX(COLLECT
Completely Stumped. For all intents & purposes, I have the same formula in two columns and one is working and one is not. Would be grateful for a solution. The Stage: I am trying to retrieve 'yesterday's' Meter Reading (Gallons) into today's row to calculation consumption between yesterday and today. (The Formula does…
-
JOIN COLLECT - PARENT criterion
Hi there! I'm doing a cross sheet formula where I want to collect Task Names if the IP Submission Return of the child row (10/12/24 in this example) matches the Most Recent Update of the parent row. The Most Recent Update column utilizes the formula =MAX(DESCENDANTS([Actual IP Submission Date]@row), DESCENDANTS([IP…
-
Access & Work Off-line within Smartsheet (Sheet level)
Enhancement Request: Access Smartsheet off-line and allow work to be saved for upload at a later time or once online access is available. The most common use case is travel (i.e. airplane, passenger in automobile). However, there are scenarios where internet service is compromised (i.e. warehouse buildout, remote areas…
-
Is there a way to scan info with an iphone and have it inserted into a form?
We need to enter VIN numbers into a form and would love to be able to scan or take a photo with an iphone or ipad and have it automatically go into the form. Is this possible with smartsheets?
-
Workspace color & logo needs to be more prominent
I use workspaces with clients and brand the workspace with the clients logo and brand colors. This used to show across the top of every page within the workspace, but a recent update has removed this so that it only appears when you have the "workspace panel" open. The result of this is that 1) the logo looks odd in many…
-
Error: Unable to Add Rows – Destination Sheet Lacks Sufficient Cells
This discussion was created from comments split from: Rows could not be added to the destination sheet because it did not have enough cells remaining.
-
SUMIF equation that pulls criterion from cell data within the row
I am trying to build a SUMIF equation (in sheet #1) that sums data (Hours Used) from a different sheet (sheet #2) if the unique ID matches. I can successfully build the equation where the 'Range' references the Unique ID column in sheet #2, the 'SUM Range' references the data to be summed in sheet #2, and the 'criterion'…
-
Select which columns to copy or move from one sheet to another
As part of the automation it is possible to copy or move a row from a source sheet to a destinatio0n sheet. At this point all columns are copied/moved, and if a column do not exist it will be created in the source sheet. The request for this improvement, is to allow the admin or owner of a sheet to select which columns…
-
Pro plan limitations
When I try to make a report on multiple sheets it tells me to upgrade my plan to pro plan. I'm already a pro plan subscriber.
-
Promo Code for Smartsheet Core Product certificate
Hi all, Can I get Promo Code for Smartsheet current month November, Ii will be very useful Thanks in Advance
