-
Limiting Characters in a Cell/Date Validation
I want to limit the number of characters that a requester can enter into a cell via a form. The use case is that the user is entering a new request for consideration into an Intake Form. In assigning a name to their project request, we want to limit them to no more than 25 characters, based on limitations from another…
-
Can licenced/unlicensed editors view hidden columns
Hi, We are trying to share a sheet with hidden confidential columns to currently unlicensed collaborators. Can they view hidden columns as editors? I think the answer is that they are not able to view hidden columns as unlicensed collaborators but I want to confirm before sharing; and check on how/if this would change if…
-
Date updating to Next Day using Index, Match, Max, Collect Formula
Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries with a date/time (Created) and by whom (Created By). I'm curious about the cell surrounded…
-
Problem with vlookup calculations
I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of a calculated field that is based on data in another Smartsheet. Users enter data…
-
Help with Metric sheet
Hello, I created this metric sheet to get totals for overall performance but I can't get the totals to populate from the sheet that is being referenced. Not sure what I am doing wrong,
-
Multiple Sheets & Formula Updates
I am using Smart Sheets for Paid Search requests. So, when an AE submits a request for their client, we ask them for specific URLs to be entered. In the sheet where they enter in their URLs (via an Update Request), there are some formulas (vlookups) that we use. For the most part, those work fine, but there are times when…
-
A sheet with links to all my SmartSheet Objects
I am looking for a way to inventory all the SmartSheet objects I am associated with Columns may be Object Type- Sheet, Report, Dashboard, Dynamic View, etc Object Name Workspace My role- Owner, Admin, Editor. etc Link to object
-
is it possible to list in the sheet the date of updating the sheet automatically?
is it possible to list in the sheet the date of updating the sheet automatically, is there any formula for it?
-
How can use the Countifs function with the Today function in the formula?
Hello, I am not sure what I did wrong in the formula that I have created. When I physically count it, I would get 23 but the formula spits out zero. I want the formula to report the number of tasks that was within the last 30 days. Here is my formula: =COUNTIF({Ready For Upload Range 4}, {Ready For Upload Range 2} <=…
-
Emailing a row from sheets does not show who is cc'd for recipient
Hi All, Something has changed recently in this process, it used to be that if I sent a row to Andy, Bob & Dan - everyone would be cc'd on the email received & when anyone responds, everyone gets a copy - and a group conversation occurs. Now, when we send a row to Andy, Bob & Dan, the recipient does not see that anyone else…