-
Control Center (can dos v cannot dos)
Does something like this exist? Just getting into working with Control Center and I keep stumbling across things I want to update/cannot update, so I started this (in early draft mode because I thought I'd ask here before I created this for myself). I am trying to find out if I can update the file names/folder names that I…
-
Retrieving Ancestor (date) value from multi-level parent-child rows
Hi All, I used the following formula to retrieve ancestor (first parent) date value of the multi-level parent-child rows for each row. =LEFT(INDEX(JOIN(ANCESTORS(Date@row), ","), 1), 8) The issue that I'm facing is the return value being "TEXT" despite having "DATE" column type. Since I have to use this return value in…
-
Create, edit, or delete a post in the Community
Log In: In order to ask or answer a question or create a post in the Smartsheet online Community, you must first set up an account (see: Getting started: Create an account). Create a Post: You can start a new Question, Discussion, or Idea by clicking New Post. Questions: only Questions can have Best Answers so choose this…
-
Forms Help!
So I know that there is no way to align submissions with specific cells, but has anyone found a creative workaround for this that still allows you to identify the submission with proper trigger data?
-
September Question of the Month 💭 Join the conversation and receive a badge
Hi everyone, We're ready to kick off September with a new question and opportunity for you to earn some badges and points while getting to know your peers! If you had your own talk show, who would your first guest be and why? Could be anyone, a celebrity, politician or historical figure just to name a few . Get creative!…
-
I am identifying the duplicates in the sheet. What wrong with this query?
=RANKEQ([Request ID]@row, COLLECT([Request ID]:[Request ID], [Item Number (SUPC)]:[Item Number (SUPC)], [Item Number (SUPC)]@row, Duplicates:Duplicates, 1), 1)
-
Merged: Validation Phone Prefix is missing for many countries
This discussion has been merged.
-
August Question of the Month 💭 Join the conversation and receive a badge!
Hi everyone, New month, new question and another opportunity for you to earn badges and points while getting to know your peers! Where or who do you turn to for Smartsheet advice? Whether the Smartsheet Community, Social channels or peers within your office we want to hear about where you get your Smartsheet advice/help.…
-
Prohibit a cell from being marked as complete
Hi everyone, Does anyone know how you can keep someone from completing a line item? I have a sheet where I ask for a resolution to an issue and some users are marking the item as complete without providing the details of the resolution. I would like to block them from the cell until data is entered into the resolution…
-
Problem with Data Shuttle that is not accepting xlsx files?
Hi All, Anyone experienced problems with Data Shuttle that it is suddenly not accepting the xlsx files from One Drive anymore? From my side when I open the file itself the section "Protect/Unprotect" sheet under Review is greyed out. Could it be that this is due to Microsoft Information Protection that I'm not able anymore…
