-
Formula for IF THEN Date
Hi all, I am trying to write a formula for an IF THEN situation but I am stuck. I need to make a formula to show a value per month only within the start date and end date. For example, below is a picture of a row on the sheet I'm working on. I need to create a formula below each month that would show the monthly production…
-
Automation Assistance
Good morning Community! I have created a sheet to keep track of all company board meetings. Each department is responsible for submitting material (attachments) prior to the meeting and automations are to be put in place to remind board members of the deadline to submit. The issue I'm having is, how can I have each…
-
Improvement of Activity Log: Display name of hidden columns
Current situation: In the activity log it is recorded if a column was hidden. But the name of the hidden columns is not visible. So it isn't traceable who has hidden which column. Requirement: Add the name of the hidden columns to the activity log.
-
Get the sheet name to reference it in automation email
Use case: User wants to setup an automation email where the sheet name can be referenced as a parameter in the subject and email text (e.g. {{sheet.name}}). Current issue: It isn't possible to reference the sheet name in automation email.
-
Formula to return first names of a contact cell.
Hello, I have a contact list column that allows for multiple contacts, and I am trying to have another column give me only the first names in text. Is there a formula to help me do that? In a cell where I have 2 contacts, I have only been able to get it to give me 1 of the first names.
-
Masking certain columns to viewers
Hi all, We have a main spreadsheet where we keep all of our projects including the budget for those projects. I would love an option where I can either share that spreadsheet, but mask certain columns or duplicate that spreadsheet, but not fill in the budget columns and then share that spreadsheet. Is there any option like…
-
Locating Form Submissions
The form is active as colleagues have told us they have submitted, but we have no idea where to find the results. The form owner is no longer available. How do we locate the results?
-
Conditionally Copy "Modified By" value to another row cell
An update to a column called, "FOO", should trigger an event where the contents of "Modified By" are copied to a column called, "BAR". Steps. 1. I change the contents for "FOO" from 'a' to 'b'. 2. "Modified By' changes to my email (the usual automated way) 3. My email is copied over to "BAR" **If a field other than "FOO"…
-
Collections not available to enterprise user on multi year contract
Hello, Our organization is on a Enterprise multi-year contract that is not on the "new user licensing model". I am an EAP user and have lost access to Collections and File Library and I understand we will not receive any of the new updates unless we switch to the new user licensing plan. What is Smartsheet doing to provide…
-
"You do not have sufficient permissions on this sheet to make this change."
Hey all, Been working with Smartsheet for years and never run into this. I was shared as an admin (I quadruple checked I am 100% an admin on both) to two sheets earlier today and am attempting to cross reference one for a fairly complex formula. Every time I try I receive this message. I logged out, had the other party…
