-
Outlook App Enhancement Request
I did submit this request through the Enhancements form. I love the Outlook app. What a time saver it is! I use the SS app religiously to save emails to my sheets. Sometimes I will save one with multiple attachments, images, only to receive an update from a co-worker and wil resave the new email. This means that the…
-
Trying to get fancy with formulas - RYG with "AND" conditions
I'm trying to get a formula that will do the following: Give me a RYG result in a column, by looking at whether a project item has gotten close to the due date, compared to what the status is on that item. I want it to give a Red result if it is within a specific number of days of the due date and has less than 25%…
-
Regular Meetings on a Project Schedule
New to smartsheets. How do I add in weekly meetings into a project (all on one line.) It is a long project and I don't want an entry for each meeting. Thanks in advance.
-
1st digit disappears
When I click into a field to enter data, the first digit, whether letter or number, disappears after I type the 2nd digit. I have to go back and add the first digit. It never disappears the 2nd time. I'm using Safari. Is this a known issue with a work around? This happens very frequently, but not all the time. It is very…
-
Linking Data
I need help linking data from one sheet to another. I need the data to update real time, so that should a salesman update a projects, or ad another project in that satisfies certain requirements, the data automatically updates in real time on the linked page for my operations team. Reports will not work for this.Reports…
-
Checkbox Checked depending on text
Should be simple, but I'm struggling. Two columns Text Column that contains some text. Checkbox Column I would like a folmula for the checkbox column to check the text column for some text. If the text column contains the text, mark the checkbox checked. Can this be done?
-
Auto-assign sequenced number to new project(s) sheet
Is there a way to automatically assign a uniquely sequenced ID# to each newly created project sheet? We'd like to do this for/across a group of users that collaborates on short-termed projects (3-6 mos). Basically have the application assign a unique and automatically sequenced ID# for each new project. Thanks in advance.
-
copy row from one sheet to another by using the formulas of the new one
Hi @ all, I haven't found any solution regarding by topic within the community articles. So maybe there is a smooth and easy solution for my question. We set up 8 identical sheets (formulas, rows) with a lot of fomulas. Why 8 sheets - because the maximum of a smartsheet sheet is by 5000 rows. ;) So if we would like to copy…
-
Multifamily Unit Turn Management Template
Good afternoon, Does anyone have (and if so are you willing to share) a template for keeping track of unit turns at an apartment complex? Thanks!
-
Automatic Update Request Based on Last Updated
I am looking to send out an automatic update request based on a system generated LAST UPDATED column if last updated was 10 days ago. The problem is, this function doesn't appear to be available in the alerts and actions and if i set up a reminder column, when the reminder triggers a check box or date, it updates the…