-
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…
-
I need to have a count down from Column A Date with the current date and show the number in a column
Colum A Date - has a date ( if in the future ) Colum B - should show me the countdown as per the current date
-
Calculate number of days per month within a date range that spans more than one year
I have a schedule that spans (2) calendar years. I want to return the number of days per month included in the range. Since I use this result for billing purposes, I have a column per month and year of the schedule the returns the number of days in that given month/year. I am running into problems once I get to the same…
-
Index/Match Leaving Blanks + "#NO MATCH"
I apologize if this posts twice... I am a relatively new Smartsheet-er experimenting with the capabilities of the Index/Match function. I have two sheets, one that tracks project status, and one that I would like to link to the first, showing live project status updates by matching the ID # columns. I have created a…
-
Why is my IF(AND(HAS function only checking part of the AND statement?
I am using a checkbox column to return 1 if a row on this sheet matches the Student Name and Location Name on a row of another sheet. Formula: =IF(AND(HAS({Extern}, [Student Name]@row), HAS({Location_No_ID}, [Assigned Clinic]@row)), 1, 0) The result is showing a checkbox when only part of the statement is true. I need both…
-
Formula to show duration days in Months, Weeks, and Days
I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see). For example, if something is 38 days, I want it to…
-
Visibility on Form Submission
Is there a way to increase visibility for requestors on their submitted requests? Like is it possible to send the requestors all of the requests they've submitted so they can see what they've requested, date, description, etc.
-
Introduction | Hello Smartsheet Community!
I am an Associate Director of Program Management based in Austin, TX. I've spent the last 7 years of my professional life working for one of the globe's largest and best-known interactive agencies. I use Smartsheet daily to manage multiple projects - both for client execution & internally based initiatives. I am considered…
-
Recommendations for Mass Comms Content Calendar
I'm researching different templates within Smartsheets that would best fit the needs of a few internal teams for a mass content calendar to manage scheduling for external outreach among overlapping constituents. On a basic level, we can enter information on the regular sheet grid and flip to calendar view as needed,…