-
Function Question
If a cell is check marked "✓" then I want a cell next to it to show the value of another cell. Then I want all subsequent cells underneath to run a value of that cell plus the value of the previous cell(s) only when checked. How would I create the formula for that please? For example if N3 is "✓" then M3 equals value of C3…
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Automated Workflow Notifications
Hi everyone, Is anyone having issues with notifications? Since yesterday, I've had a few automated workflows that, when triggered, are not sending the email notification or even alerting the user via the Notification bell.
-
Admin Center User Auto-Save Default setting Control
When a new account is created, auto-save is automatically turned on. In our company, we would like to disable auto-save by default. However, there is no way to set the default setting for this in the Admin Center. Many of our users have many Tabs open and use multi-screens. We want to avoid them accidentally overwriting…
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
-
Sheets shared with me
The feature allowing you to see who created the sheet directly from the shared sheets list has recently been changed. Now, you can only view the sheet name and the date it was last updated. To see the owner or who shared the sheet with you, you need to right-click on the sheet name and select Properties. This has a direct…
-
Get a list value from another sheet
Hi All, I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet? Thanks
-
Populate Column From Another Sheet's Dropdown Menu
Hi all! I was wondering, is it possible to populate an entire column based on the dropdown menu from another sheet? I have one sheet where all tasks are listed, and are assigned to people via a dropdown menu. I am trying to create another sheet as a cross sheet reference that summarizes hours of every individual. What I…
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Can't see the Dynamic View menu option on Sheet
I can see the Dynamic View menu option on top of the Sheet. Other users cannot. Do you know why? They only see File, Automation, Forms, and Connections. And what must they do to see it as well? Thanks.
