Looking to assign a % complete to a project based on days from open to estimated close. Have a column showing total network days from these dates and now want to either nest a function to subtract the overall days from the current days (open to estimated close minus open to today). I am new to
I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment.
Another solution I'm
I have created a construction schedule where i have many lines of of tasks that apply in a mixed format to different subcontractors. Each task has it own % value. I have created another sheet where I have listed the Subcontractors and am trying to roll up the %of every line (associated with a
We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto
I am auto-forwarding certain emails from Outlook to a Smartsheet list via Zapier.
Everything comes across fine but certain data fields seem limited in space. The body of the email doesn't fully transfer. It seems there is a character limit to either the Zapier forward or to Smartsheet. How can
I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year.
| January | 45 |
| February| 20 |
However, I am finding trouble actually calculating the amount based off of the
I have a formula =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue??
Please see attached excel with formula in Column D
Thank you in advance :)
I'm trying to figure out the correct formula for counting up the # of entries for a particular location with a "YES" or "NO" data entry for the previous date, TODAY (-1), that doesn't include weekends.
For instance, if today=Monday, then the formula would need to search for the previous Friday date