Cash Flow Projection in Projects Sheets

Jorge Escoto

Hi, I am using =IF(AND(  ... )) to project in which month a disbursement will be made in a project planning sheet. 

Does anyone use an easier faster way of scheduling disbursements and depreciation?

Regards

Shaine Greenwood

Hi Jorge,

I'm not sure how your sheet is structured, but you might try creating a lookup table with your disbursements and using that: https://help.smartsheet.com/function/lookup

Otherwise, you can find our complete functions list here: https://help.smartsheet.com/functions