-
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…
-
Automatically Generate Decision Log from Action Item List
I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever the value of “move to decision log” is selected from the next steps column in the action item log I would like for a line item…
-
Formula Counting Courses Required /Taken
All, Have a smartsheet that shows by student (each row is a student) what course they are required to take. The student updates the date they completed the course via update requests. Based on this smartsheet I am trying to find a formula that will show me when they have completed all courses that they are required. The…
-
Checklists on tablet/device
I am just wondering if there is a better way to set up QA sheets so that they are able to easily be checked off on a device (tablet/iPad)? It would be great if we could just go line by line touching the box to tick it, but what actually happens is the edit line page appears and it has to be filled out that way - which is a…
-
COUNTIFS Question
I'm having an issue understanding COUNTIFS in my scenario. I'm trying to track billable hours, and I'd like to summarize the hours value listed if another column equals a specific value. So I can track how many hours go to which projects. I believe COUNTIFS is the right formula to use, but not sure how to apply it. Any…
-
Sheet ownership in the workplace
Summary : 2 questions. 1. Moving sheets in a workspace changes ownership - Why - can I stop this happening 2. Reporting in workspace does not appear to allow for additional sheets in a workspace folder to be updated to the report.?? When creating the report and the folder inside the workspace is selected it shows only the…
