-
Formula Help
Hi. I am a project manager for a design build company and I am creating a template to use to forcast the labour required on a job that automatically decreases based on the percentage complete. I am wanting to add a formula to one of my sheets that will automatically populate up to 4 column cells based on an option chosen…
-
Assigned to = sheet owner?
Is there a formula or reference for an assigned to column that would automatically be the sheet owner? I'm trying to setup an automatic reminder email to a sheet's owner two weeks before a milestone date.
-
Gantt Sheet - Linking Dates
How can I generate the sub dates on a Gantt sheet using the duration? I would like to be able to copy my project and the subdates automatically generate from the head date? This could be generated by the duration. For example If the Head start date is 1/3/2016 I would like the sub dates to auto generate from the duration…
-
160 character limit in field (used for sms)
Is is possible to set a l60 character limit to a field? The reason for this is that we collect texts from users (mostly by web form) that we will use for sms, but usually they write more than 160 characters which leads to extra work.
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
Formulas and Data Rollup
Hi, I am in the process of putting together a sheet that logs the amount of production each day. As a bit of background we are an aggregate manufacturing and contracting business and what i am trying to do is have a sheet that tracks the amount of production of each product per day. I have created a sheet with all the…
-
Manage time entries based on previous ones
Hello! The use case I am trying to enable is that when a user makes an entry it should not exceed a set cumulative time (eg 120 minutes). So user 1 enters 90 minutes, user 2 enters 40 minutes in the cell below it which exceeds the alloted time by 10 minutes. Can this trigger a warning or validation that prompts for a…
-
Sumif with child based on criteria of other column?
I'm needing to get the SUM amount of dollars from the "Budget" column if that row is a "1" in the Quarter column...the rows are children...please help?
-
Can If-Then formula populate Primary column?
I need to populate the information in the primary column from a dropdown menu but cannot because of the type of column. If I place a column next to it with the dropdown information, can I use an If-Then formula such as =IF(ISTEXT([Client name drop down list]1), "Text", "Not Text") where I change the "Text" to equal…
-
Use a formula in project sheet start date for milestone?
Is it possible to use a formula in a project sheet's start and/or end date columns? I'm trying to have a date entered into a start date column in the project sheet based on a date entered as text in another text column. I've already found a formula that works to convert date-as-text to a date format, and I've confirmed the…
